Travel allowance
Posted: Mon Jul 11, 2016 1:05 pm
Pls... Need help on below excel formula~
Example I went to travel 19 days and travel allowance base on this:
1-5 days - claim 40 per day
6-10 days - claim 50 per day
11-15 days- claim 60 per day
16-20 days - claim 70 per day
Answer is 40x5 days + 50x5days + 60x5days + 70x4days
1030 in total
Anyone hv the idea on this formula?
Example I went to travel 19 days and travel allowance base on this:
1-5 days - claim 40 per day
6-10 days - claim 50 per day
11-15 days- claim 60 per day
16-20 days - claim 70 per day
Answer is 40x5 days + 50x5days + 60x5days + 70x4days
1030 in total
Anyone hv the idea on this formula?
