Excel n00b, how to do basic math functions
(1)
Column C has miles
Column D has gallons
I wish to have Colum F determine MPG or C÷D=F
(2)
Column B has Odometer reading
Row 2B has start, Row 9B has end
I wish to have Row 10B determine total miles or 9B-2B=10B
(3)
Column C has Trip Odometer reading
Row 3C-7C and 9C has mileage since last fillup
I wish to add each designated value to a running total at 10C
(4)
Column E has cost per gallon
Row 3C-7C and 9C has cost/gal at each gas stop
I wish to add each designated value to a running total and divide by
number of gas stops to get average cost per gallon.
Thanks for your help.
|