Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mileage calculation
I am creating a spreadsheet that will work out how much petrol money a worker
can claim back. The claim is based on usage, anything below 666 miles petrol is calculated at 32p and then anything over that petrol is calculated at 16p how can i get the total claim cell to calculate for the example a worker who travelled 812 miles? |
#2
|
|||
|
|||
=32*min(miles,666)+16*max(miles-666,0)
"Hardy03" wrote: I am creating a spreadsheet that will work out how much petrol money a worker can claim back. The claim is based on usage, anything below 666 miles petrol is calculated at 32p and then anything over that petrol is calculated at 16p how can i get the total claim cell to calculate for the example a worker who travelled 812 miles? |
#3
|
|||
|
|||
=(miles*16+MIN(miles,666)*16)/100
and format as currency -- HTH RP (remove nothere from the email address if mailing direct) "Duke Carey" wrote in message ... =32*min(miles,666)+16*max(miles-666,0) "Hardy03" wrote: I am creating a spreadsheet that will work out how much petrol money a worker can claim back. The claim is based on usage, anything below 666 miles petrol is calculated at 32p and then anything over that petrol is calculated at 16p how can i get the total claim cell to calculate for the example a worker who travelled 812 miles? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equity buildup calculation | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |