Mileage cost Tracker Part II

Hello

I previously posted a problem with this spreadsheet and had great help from John Topey.

I work in a hospital and had been tasked with calculating/tracking the total mileage spend in a year.

Now the task is to reflect the actual cost in a monthly format,

example Table A, March 18 (cell P9) = 50 KM. Table B needs to reflect the correct cost for March 18 based on the variables, i.e what vehecile size, how many kms covered already and what rate should be applied

I’ve attached a small sample of the spreadsheet:-

Variables
Distance travelled
Engine size
Variable rates applied based on distance travelled

Example :- car size is 1200cc, then a rate of €0 .3795/km is applied, up to the first 1500Km, then anything above 1500km a rate of €0.7000/km applied up to 5500km. Above 5500km the rate changes again to €0.2755. Then from 25001kms to infinity it changes to €0.2136/km.

Again I am stumped, I have been working on this for a couple of weeks now with no luck so any help is greatly appreciated

Rgd’s

John