I am trying to find a Formula for a cell on a spreadsheet that will calculate a financial penalty for anyone doing more than 60 private miles per week, but do nothing if they are under the 60 miles threshold.
- H4 = Private miles completed (Imported from another cell on the sheet)
- I4 = Miles above the 60 miles threshold
- J4 = Financial Penalty (Currently £0.15 per mile over 60)
If H4 is equal to or less than 60, I want I4 & J4 to show 0.00 & £0.00
(ie... H4 = 49.00, I4 = 0.00, J4 = £0.00)
If H4 is greater than 60, I want J4 to calculate the additional miles above the 60 miles threshold multiplied by £0.15 per mile.
(ie... H4 = 82.00, I4 = 22.00, J4 = £3.30)
Thanks in advance for any help to a complete excel novice..!!