Using excel to calculate taxi fares

[venshi]

Basic Fare ($)	Normal	Medium	Large
Flag Down Fee (Inclusive of the first KM	3.00	3.90	5.00
Every 400m thereafter or less up to 10km	0.22	0.25	0.33
Every 350 metres thereafter or less after 10 km	0.18	0.20	0.28
Every 45 secs of waiting or less	0.20	0.20	0.20

<tbody>
</tbody>

I am really new to excel and I really do not know which formula to even use to calculate the taxi fare according to this table where there are 3 types of taxis. I have seen examples of taxi fare questions in this thread, however, how do you solve the issue if it charges by 400m and 350m as seen in the table? I tried changing the price to /km for easier calculation, however, one flaw is that if a vehicle travels 8.5 km, for example, the result will no longer be accurate. Can any kind souls please enlighten me?

 

[shg]

Cross-posted at https://www.excelforum.com/excel-fo...9679-using-excel-to-calculate-taxi-fares.html

 

[venshi]

Thanks for pointing out! However, the formula seems flawed as hiring a normal taxi is more expensive than medium and getting the value for a large taxi is unavailable with an error and I can't figure out what is wrong. Can anyone help me here pls