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?

=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?

=(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?