how to calculate mileledge

  • Thread starter Thread starter wealo
  • Start date Start date
W

wealo

i always travel, and to do claiming to my dept is very diffcult to me
when it come to miledge. the rate table is as below.

first 500km - 0.65 cent.
150km after 500km - 0.60 cent
150km after 650km - 0.50 cent
150km after 800km - 0.45 cent
150km after 950km - 0.40 cent
150km after 1100km - 0.35 cent
every km after 1100km - 0.20cent


pls help me to solve this problem.
 
wealo said:
i always travel, and to do claiming to my dept is very diffcult to me
when it come to miledge. the rate table is as below.

first 500km - 0.65 cent.
150km after 500km - 0.60 cent
150km after 650km - 0.50 cent
150km after 800km - 0.45 cent
150km after 950km - 0.40 cent
150km after 1100km - 0.35 cent
every km after 1100km - 0.20cent


pls help me to solve this problem.
Click to expand...

Shouldn't the last 1100 be 1250?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I apply State O Maine 5% Sales Tax schedule to $ amounts. 16
table/dropdown calculation HELP PLZ 2
Formula to link a few cell to Calculate 1
A formula to choose the correct table for my template 2
Any sugguestion to set up this Calculation? 10
HELP!! Need to edit variables in an access file. 2
not sure how to do this 1
Please help FORECAST formula 0

Back
Top