MPH, MPG Calculation

[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

 

[David McRitchie]

Hi Joe,

If you have a table of MPG at different speeds you can use
VLOOKUP. Some examples on
http://www.mvps.org/dmcritchie/excel/vlookup.htm

Or if your fuel injectors leak your mileage improves as speed
increases up to a point.

 

[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,

If you have a table of MPG at different speeds you can use
VLOOKUP. Some examples on
http://www.mvps.org/dmcritchie/excel/vlookup.htm

Or if your fuel injectors leak your mileage improves as speed
increases up to a point.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

 

[L. Howard Kittle]

Hi Joe,

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

Enter MPH in cell C1

HTH
Regards,
Howard

 

[Joe]

Hi Joe,

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

Enter MPH in cell C1

HTH
Regards,
Howard

Thanx Howard, That was just what the DR. ordered

Joe