TERMN8R
Full Member
Could not resist. This will give you the miles to break even on a mod. Yes, I did it in Excel too. Works great. We all know that we do not mod for mileage, we mod to make it "ours."
Excel:
=(B3/B4)*(1/(1/B5-1/B6))
B3 is the cost of the mod (ex. $500)
B4 is the cost of gas (ex. $1.89)
B5 is the old mpg (ex. 15)
B6 is the new mpg (ex. 17)
B7 is the miles to break even
Should be 33,730.16
Excel:
=(B3/B4)*(1/(1/B5-1/B6))
B3 is the cost of the mod (ex. $500)
B4 is the cost of gas (ex. $1.89)
B5 is the old mpg (ex. 15)
B6 is the new mpg (ex. 17)
B7 is the miles to break even
Should be 33,730.16