View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Omohundro Omohundro is offline
external usenet poster
 
Posts: 4
Default 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.