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

1. ## 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

2. ## Re: calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rat

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

3. ## Re: calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rat

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

4. ## Re: calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rat

Sorry, brain fart.

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

5. ## Re: calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rat

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!

6. ## Re: calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rat

Thanks for the feedback. Glad I could help.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1