calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rate

I want a formula to perform the following:

the first 2 miles to be charged at £3.50 inclusive; for example regardless if they travel 1/2 mile, 1 mile, 1.5 miles or 2 miles, the charge is £3.50. Once that threshold is reached, anything in excess of 2 miles is charged an additional 1.67 per mile

Therefore a passenger travelling:

1 mile charge = £3.50, 2 miles = £3.50, 3 miles = £4.67, 4 miles = £6.84

The current formula I have just needs tweaked =IF(C4<3,C4*3.5,(2*3.5)+((C4-2)*1.67)) since the results are as follows:

1 Mile £3.50
2 Mile £7.00
3 Mile £8.67
4 Mile £10.34



Thanks in advance,

=if(c4<=2,c4*3.5,3.5+((c4-2)*1.67))

Originally Posted by daffodil11

=if(c4<=2,c4*3.5,3.5+((c4-2)*1.67))

Based on revised formula this is what Ive got, but I know this is incorrect e.g 2 miles should still be £3.50, I think all other calculations are fine, just the "2 miler"

=IF(C4<=2,C4*3.5,3.5+((C4-2)*1.67))

Mileage Transport Cost (3.50 per mile, for first 2 miles) then 1.67
0 £0.00
1 £3.50
2 £7.00
3 £5.17
4 £6.84
5 £8.51
6 £10.18

Sorry, brain fart.

=IF(C4<=2,3.5,3.5+((C4-2)*1.67))

Originally Posted by daffodil11

Sorry, brain fart.

=IF(C4<=2,3.5,3.5+((C4-2)*1.67))

Thats it, thank you, very much appreciated!

Thanks for the feedback. Glad I could help.