Using excel to calculate taxi fares

[venshi]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Basic Fare ($)[/TD]
[TD]Normal[/TD]
[TD]Medium[/TD]
[TD]Large[/TD]
[/TR]
[TR]
[TD]Flag Down Fee (Inclusive of the first KM[/TD]
[TD="align: right"]3.00[/TD]
[TD="align: right"]3.90[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]Every 400m thereafter or less up to 10km[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD]Every 350 metres thereafter or less after 10 km[/TD]
[TD="align: right"]0.18[/TD]
[TD="align: right"]0.20[/TD]
[TD="align: right"]0.28[/TD]
[/TR]
[TR]
[TD]Every 45 secs of waiting or less[/TD]
[TD="align: right"]0.20[/TD]
[TD="align: right"]0.20[/TD]
[TD="align: right"]0.20[/TD]
[/TR]
</tbody>[/TABLE]








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