M
markinva
Sorry for the long post!
Please see the attached Word doc - it has a table that I copied from a
spreadsheet I'm working on. I included each cell's formula to help
explain what I'm trying to do.
As you can tell, I'm creating a kind of fuel calculator/comparison
chart. I want to be able to compare the amount spent over a year for a
couple of vehicles with a certain mpg rating. There's more to the
chart, but this information is sufficient for my question/problem.
I'm including fuel prices from $1.50 to $4.00 (man, can you believe
prices these days?! ). That's two hundred and fifty rows of fuel
prices - per car. Obviously I'm trying to find the quickest way to get
the formulas in the corresponding columns.
What I tried to do was drag, for instance (in the attached table) cell
B10 down. To make the chart work, the first cell in the formula must
change to reference the fuel price in the next row, but the reference
to the car's gallons used must stay the same. But what actually happens
when I drag the cell is *both* parts of the formula change to reference
the next cell down from each cell refernced in the formula. So dragging
from B10 down, it changes to "=(A11*C4) when I want it to read
"=(A11*C3)".
Is everyone thoroughly confused? Good! Now for the question:
Is there anyway to automate or otherwise speed up the formula entry
instead of manually entering all 250 - sorry *500* formulas (for the
two cars' colums)?!
Edit: I have never ventured in to using any special commands (vlookup,
pmt, even SUM) but I'll learn...
Thanks for anyone's help!
Mark
+-------------------------------------------------------------------+
|Filename: Fuel calculator example.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3701 |
+-------------------------------------------------------------------+
Please see the attached Word doc - it has a table that I copied from a
spreadsheet I'm working on. I included each cell's formula to help
explain what I'm trying to do.
As you can tell, I'm creating a kind of fuel calculator/comparison
chart. I want to be able to compare the amount spent over a year for a
couple of vehicles with a certain mpg rating. There's more to the
chart, but this information is sufficient for my question/problem.
I'm including fuel prices from $1.50 to $4.00 (man, can you believe
prices these days?! ). That's two hundred and fifty rows of fuel
prices - per car. Obviously I'm trying to find the quickest way to get
the formulas in the corresponding columns.
What I tried to do was drag, for instance (in the attached table) cell
B10 down. To make the chart work, the first cell in the formula must
change to reference the fuel price in the next row, but the reference
to the car's gallons used must stay the same. But what actually happens
when I drag the cell is *both* parts of the formula change to reference
the next cell down from each cell refernced in the formula. So dragging
from B10 down, it changes to "=(A11*C4) when I want it to read
"=(A11*C3)".
Is everyone thoroughly confused? Good! Now for the question:
Is there anyway to automate or otherwise speed up the formula entry
instead of manually entering all 250 - sorry *500* formulas (for the
two cars' colums)?!
Edit: I have never ventured in to using any special commands (vlookup,
pmt, even SUM) but I'll learn...
Thanks for anyone's help!
Mark
+-------------------------------------------------------------------+
|Filename: Fuel calculator example.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3701 |
+-------------------------------------------------------------------+