O
office
Hi,
Trying to get a formula that will do the following:
My company pays 40 pence a mile up to 833 miles, all miles after this get
paid at 25 pence a mile.
Is there a way I can get a formula to calculate this??
e.g. I do 2641 miles in August -
833 @ £0.40 = £333.20
1808 @ £0.25 = £452.00
Total = £785.20
2641 = £785.20
Thanx in advance
Rick
Trying to get a formula that will do the following:
My company pays 40 pence a mile up to 833 miles, all miles after this get
paid at 25 pence a mile.
Is there a way I can get a formula to calculate this??
e.g. I do 2641 miles in August -
833 @ £0.40 = £333.20
1808 @ £0.25 = £452.00
Total = £785.20
2641 = £785.20
Thanx in advance
Rick