how to calculate mileledge
 

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
------------------------------------------------------------------------
wealo's Profile: http://www.excelforum.com/member.php...o&userid=15703
View this thread: http://www.excelforum.com/showthread...hreadid=272328

how to calculate mileledge
 

"wealo" schreef in bericht
...

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

Shouldn't the last 1100 be 1250?