MPH, MPG Calculation

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hi ppl,

I have a sheet that, part of it references MPG. the only problem is MPG is
highly affected by speed. What I have so far is =IF(J4<=72,5.5,4.5) The
sheet adjusts MPG above and below a certain speed. In this case 72mph, what
I want to combine other speeds into a formula so I can get for example

60 mph =6mpg
65mph = 5.75
75 mph = 4mpg and so on .

MPG is also affected by weight, but is not that important a factor for what
I need, although it would be nice. TIA for any help

Joe
 
Ok Thanx Dave, but MPG decreases with increased speed in this case,

Maybe I wasn't clear enough cell C4 is the cell that the result
of=IF(J4<=72,5.5,4.5) will appear in ( there are other cells dependent on
what is displayed in C4) , and J4 is where the speed is entered manually.
what Im trying for is a formula that takes into account the speed to come up
with the MPG, by entering the speed in J4 if that's possible
 
Hi Joe,

=LOOKUP(C1,{60,65,70},{6,5.75,4})

Enter MPH in cell C1

HTH
Regards,
Howard
 
Back
Top