Need help with Microsoft Excel....
09-12-2005, 09:49 AM
#1
0.0 BAR
Thread Starter
Join Date: Jun 2003
Posts: 0
Need help with Microsoft Excel....
Alright The equation is:
(1+I)^n
I is in cell I1 and n is the number of cycles listed in colum A starting at A4. Whoever helps me out can change Junkyard Racers title to whatever they want it to say.
Thanks.
(1+I)^n
I is in cell I1 and n is the number of cycles listed in colum A starting at A4. Whoever helps me out can change Junkyard Racers title to whatever they want it to say.
Thanks.
09-12-2005, 10:14 AM
#3
0.0 BAR
Thread Starter
Join Date: Jun 2003
Posts: 0
Re: Need help with Microsoft Excel....
Originally Posted by civicvtecb16a
n7? 
I need what the equation would be that I have to enter in that repeats that equation 100 times using the number in I1 and N being the number in colum a1. I know there's computer nerds on here that are good at this stuff...
09-12-2005, 10:21 AM
#4
0.0 BAR
Join Date: May 2005
Posts: 8
Re: Need help with Microsoft Excel....
If I understand what you are trying to do, you have a number in I1, and a list of 100 other numbers in column A (starting at A1?) and you want to take the number in I1, add 1 to it, and then increase in exponentially by the number listed in column a... 100 times, for the entire list? Essentially you are looking for 100 answers to your calculation?
=($I$1+1)^A1
Drag that formula down, until A1 is A100, and you should be set....
=($I$1+1)^A1
Drag that formula down, until A1 is A100, and you should be set....
09-12-2005, 10:25 AM
#5
0.0 BAR
Thread Starter
Join Date: Jun 2003
Posts: 0
Re: Need help with Microsoft Excel....
Originally Posted by No SKills
If I understand what you are trying to do, you have a number in I1, and a list of 100 other numbers in column A (starting at A1?) and you want to take the number in I1, add 1 to it, and then increase in exponentially by the number listed in column a... 100 times, for the entire list? Essentially you are looking for 100 answers to your calculation?
=($I$1+1)^A1
Drag that formula down, until A1 is A100, and you should be set....
=($I$1+1)^A1
Drag that formula down, until A1 is A100, and you should be set....
We have a winner. Yeah thanks alot. I couldn't figure out how to stop I1 from changing to I2 and so on. thanks.
09-12-2005, 12:29 PM
#7
3.0 BAR
Join Date: Feb 2003
Posts: 9,089
Re: Need help with Microsoft Excel....
Originally Posted by kain
excell if fucken messed up man. i had to take a class on it and bareley passed that section.
the $ locks the cell in that place even if u move or copy it around.
I$1 would have worked too, as long as you didnt copy sideways.
09-12-2005, 12:29 PM
#8
1.5 BAR
Join Date: Jun 2003
Posts: 681
Re: Need help with Microsoft Excel....
as a tip, if you ever need a cell to remain the same when you drag it, use the absolute reference ----, you can hit F4, basically it puts the dollar signs in front of the cell reference, like if you have cell A1, it would be $A$1, if you wanted just the column to stay a, then only put the dollar sign before the a...
excel sucks
excel sucks
Thread
Thread Starter
Forum
Replies
Last Post
Badass86
Forced Induction
1
04-13-2015 10:42 PM
biggmike
General Discussion
42
11-23-2004 12:02 AM
