mileage calc

[Trevor3007]

Hi,

Have tried & tried to sort this myself, but cannot & hoping Mr excel can provide the answer?

I am tryin to create a expenses calculation for mileage . But its not stright forward ( well for me that is).

For example, the total milage from start post code to end post code = 205miles.

I have to knock off the 1st 30 miles =175
The company allows 0.40 between 1 - 75miles = 75 x 0.40=£30
The comapny allows 0.20 for anything over 75 miles = 100 x 0.20 =£20

My issues are:-
I need to have something that when the total mileage meets the above , but also when the total mileage does not
For example, the total milage from start post code to end post code = 50 miles,

knock off the 1st 30 miles =20
The company allows 0.40 between 1 - 75miles =20 x 0.40 = £8

Also, as I will doing multi rows, if A2 ,a3, a4 etc is blank, than all the retrospective cells in that applicable row will be blank too ( just to keep things tidy)

I have treid to do this all on one row , so all I have to do is enter the total milage from start post code to end post code in A2..

Hoping this makes sense & thank you for helping me & taking up my issue.

 

[Fluff]

Glad we could help & thanks for the feedback.