I need some help with what I though was a simple formula, but turns out it isn't.
I need to work out the servicing cost of an asset, depending on the number of miles travelled, which varies from asset to asset. The servicing costs also vary at different intervals.
For example in the attached, I need to work out the servicing cost for the year for W1234, which has a start mileage of 7,000 miles and finish at 8,250. I need the formula to return that it requires a service at 7,000, 7250, 7500, 7750, 8000, and 8,250 miles, with a total cost of £4,122 (including the 7,000 mile service). This needs to go into cell D2.
I feel it's a simple lookup and sum joint effort, but can't for the life of me work out how to do it.
Thanks in advance.
Bookmarks