Excel Help Please!!!!! - U2 Feedback

Go Back   U2 Feedback > Lypton Village > Lemonade Stand > Lemonade Stand Archive
Click Here to Login
 
 
Thread Tools Search this Thread Display Modes
 
Old 08-21-2003, 12:02 PM   #1
Rock n' Roll Doggie
 
ouizy's Avatar
 
Join Date: Jan 2001
Location: s p o r a t i c
Posts: 3,788
Local Time: 08:41 AM
Excel Help Please!!!!!

Anyone here a whiz at Excel?

I have a question that 3 people so far have not been able to answer. I will try to make sense of this, but here is what I am trying to do:

I have a column of numbers, every day I add a new number to the bottom of the column.

I have an equation that is complicated, but I will use a simple one here to find what I need to do.

Let's say I want to add the top number (which is always constant) to the bottom number in the column. I can write the equation to do this, but since I am adding a new number every day at the bottom of the column, I want Excel to always use the last number in the column.

The analogy would be "n+1" where "n" is the previous entry, and "n+1" is the last entry.

So the simple equation would be (assuming A1 is the top cell):

=A1+(AN+1)

so let's say the last cell in the column is A8 the equation would be
=A1+N where N is the cell A8. OR,

=A1+A8.

Now let's say I want the equation to always add the next cell which would be A9 - so it would be

=A1+(AN+1) where the (AN+1) is equal to A9.

The real question is, in Excel how do I input a value into my equation that represents (N+1)????


If anyone can help me I would very much appreciate this.



Always calculating,
__________________

__________________
ouizy is offline  
Old 08-21-2003, 12:17 PM   #2
An Angel In Devil's Shoes
 
ABEL's Avatar
 
Join Date: Jan 2001
Location: Netherlands
Posts: 18,844
Local Time: 07:41 AM
my brain hurts now






sorry I don't know the answer tho.
__________________

__________________
ABEL is offline  
Old 08-21-2003, 02:02 PM   #3
Rock n' Roll Doggie
 
ouizy's Avatar
 
Join Date: Jan 2001
Location: s p o r a t i c
Posts: 3,788
Local Time: 08:41 AM


a-ha - I figured it out. The equation I was trying to write ended up being:


=((OFFSET(BASEE,COUNT(BASEE:E60000)-1,0)-BASEE)/(OFFSET(BASEE,COUNT(BASEE:E60000)-1,0))*100)


If anyone here even spent 3 seconds thinking about this, thanks.


Any mods out there? You can CLOSE this thread if you feel like it...
__________________
ouizy is offline  
Old 08-21-2003, 02:53 PM   #4
ONE
love, blood, life
 
Join Date: Aug 2001
Posts: 11,961
Local Time: 08:41 AM
Normal that looks like math.

Quote:
Originally posted by ouizy
=((OFFSET(BASEE,COUNT(BASEE:E60000)-1,0)-BASEE)/(OFFSET(BASEE,COUNT(BASEE:E60000)-1,0))*100)
that terrifies me.

__________________
Screaming Flower is offline  
Old 08-21-2003, 04:07 PM   #5
ONE
love, blood, life
 
zonelistener's Avatar
 
Join Date: May 2001
Location: six convenient metro locations
Posts: 14,747
Local Time: 08:41 AM
I like count basie
__________________
zonelistener is offline  
Old 08-21-2003, 04:42 PM   #6
Rock n' Roll Doggie
FOB
 
Lilly's Avatar
 
Join Date: Oct 2001
Location: back and to the left
Posts: 8,523
Local Time: 07:41 AM
wait till salome gets here.
__________________
Lilly is offline  
Old 08-21-2003, 05:16 PM   #7
Rock n' Roll Doggie
 
ouizy's Avatar
 
Join Date: Jan 2001
Location: s p o r a t i c
Posts: 3,788
Local Time: 08:41 AM
Re: that looks like math.

Quote:
Originally posted by Screaming Flower


that terrifies me.

I did not mean to scare you, I just needed some help. Then I figured it out, and my shit clicked together.

Hi Flower.



__________________
ouizy is offline  
Old 08-21-2003, 06:56 PM   #8
Acrobat
 
Squishy Peanut's Avatar
 
Join Date: Jun 2003
Location: Surrey, UK
Posts: 383
Local Time: 01:41 PM
Quote:
Originally posted by ouizy


a-ha - I figured it out. The equation I was trying to write ended up being:


=((OFFSET(BASEE,COUNT(BASEE:E60000)-1,0)-BASEE)/(OFFSET(BASEE,COUNT(BASEE:E60000)-1,0))*100)
you 'figured it out'?! I can't even thing up horrible strings of numbers and letter like that in my worst nightmares!



*looks at it again....goes cross eyed*




Go you?
__________________
Squishy Peanut is offline  
Old 08-21-2003, 07:04 PM   #9
Offishul Kitteh Doctor
Forum Moderator
 
bonosloveslave's Avatar
 
Join Date: Aug 2002
Location: Taking care of kitties
Posts: 9,655
Local Time: 08:41 AM
__________________
bonosloveslave [at] interference.com
bonosloveslave is offline  
Old 08-21-2003, 08:40 PM   #10
Rock n' Roll Doggie
VIP PASS
 
cell's Avatar
 
Join Date: Nov 2000
Location: Disneyland
Posts: 5,901
Local Time: 06:41 AM
Quote:
Originally posted by ouizy




=((OFFSET(BASEE,COUNT(BASEE:E60000)-1,0)-BASEE)/(OFFSET(BASEE,COUNT(BASEE:E60000)-1,0))*100)


me thinks im gonna install microsoft office again and try something similar...dangit now i wanna relearn excel again...
__________________

__________________
cell is offline  
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -5. The time now is 08:41 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Design, images and all things inclusive copyright © Interference.com