Calculate Limit Value Formula

[ChrisHook]

All,

I'm having a little trouble with the logic on this one. Consider the following simple example. Say my car gets 20mpg, I have a 15g tank, and I have a requirement to drive 100miles.

I want to write a formula that can dynamically calculate how many miles I can drive without running out of gas (up to my 100 mile requirement).

The formula would either result in the 1) total requirement of 100 miles or the 2) maximum number of miles I can drive until i run out of gas (if less than 100 miles).

So, if the fuel burned over the course of 100 miles is less than my 15g tank, then 100 miles is returned, otherwise return maximum number of miles I can drive until i run out of gas.

Thanks in advance.

Best,
Chris

[Sam Capricci]

so let's say A1 has the 20 in it and B1 has the 15 for your tank size, then if I'm understanding you correctly this should work for you in C1 =IF(B1*A1<100,100,B1*A1)

[crazyforexcel]

300 miles per tank which is the mpg multiplied by the gallons in each tank.

[Richard Buttrey]

...another approach with A1 = mpg 20, A2 = tank capacity 15, A3 journey mileage = 100

Maximum mileage:

Please Login or Register  to view this content.

[ChrisHook]

All, thank you for the thoughtful responses. Richard's and Sambo's solution worked great. I've ran into another problem - but would probably warrant another thread, kind of unrelated from this issue. Thanks again.