Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
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.
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.