Try copying the formula down from the starting cell, say in C1.

Drag the fill handle (the black square at the bottom right corner of C1)
down as far as there is data in cols A and B
(or you could also just double-click on the fill handle)

And you could even copy down ahead to cater for expected data in cols A and
B, if you want.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"TM" wrote in message
...
That only works for one cell in that particular row.

I want to be able to enter the miles and gallons in any row and have it
automatically calculate mpg for that row,

Here is some sample data:
Miles Gall MPG
200 10 20


That formula works great but there seems to be no way to have it use that
formula all the way down the sheet for any value entered into
miles-column,
gallons-column and have it calculate mpg

Can this be done ?
--
Tony