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?