1. Multiple condition formula help please.

I have to come up with a formula that meets the following conditions.

The formula is to calculate the cost of maintenance on a car. The cost of maintenance is .0375 cents per mile for the first 10,000 miles the car is driven per year, .045 cents per mile for each mile driven after those first 10,000 miles. Also the minimum maintenance cost is \$300, meaning that if the car is not driven at all there should still be a maintenance cost of \$300.

Any help is appreciated. Thanks

2. Re: Multiple condition formula help please.

maybe
A1= total miles run

=MAX(300,IF(A1<=10000,A1*0.0375,A1*0.045))

3. Re: Multiple condition formula help please.

The cost of maintenance is .0375 cents per mile for the first 10,000 miles the car is driven per year, .045 cents per mile for each mile driven after those first 10,000 miles.
Its only the miles above 10000 that need to be calculated at 0.045. Hence,

=MAX(300,IF(A1<=10000,A1*0.0375,375+(A1-10000)*0.045))
or
=MAX(300,SUMPRODUCT((A1>{0,10000})*(A1-{0,10000})*{0.0375,0.0075}))

There are currently 1 users browsing this thread. (0 members and 1 guests)