C
Colin Weir
Hi There
I use excel for a staff mileage sheet and have been for some time. It has been working well with no issues.
The formula calculates the mileage at 40p per mile up to 80 miles and thereafter 20p per mile. It also adds in another cell which is for additional expenses, parking etc.
The formula is
=IF(D8="","",(D8*0.2)+MIN(80,D8)*0.2+E8)
The issue I now have is that our mileage has been increased to 45p per mile for the first 80 miles and thereafter 20p per mile.
I was wondering if someone could help me with ammending this form please?
Thanks
Colin
I use excel for a staff mileage sheet and have been for some time. It has been working well with no issues.
The formula calculates the mileage at 40p per mile up to 80 miles and thereafter 20p per mile. It also adds in another cell which is for additional expenses, parking etc.
The formula is
=IF(D8="","",(D8*0.2)+MIN(80,D8)*0.2+E8)
The issue I now have is that our mileage has been increased to 45p per mile for the first 80 miles and thereafter 20p per mile.
I was wondering if someone could help me with ammending this form please?
Thanks
Colin