Using excel to calculate taxi fares

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

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 vechicle travels 8.5 km for example, the result will no longer be accurate. Can any kind souls please enlighten me? I have attached the table into a excel file for easy referencing.

=sum(hlookup(j2,$e$4:$g$8,2),hlookup(j2,$e$4:$g$8,3)*roundup((min($c$6,$k2)-1)/$d$6,),hlookup(j2,$e$4:$g$8,4)*roundup(max(,-$c$6+$k2)/$d$7,),roundup(l2/d8,)*hlookup(j2,$e$4:$g$8,5))

Thanks for your help!!! 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.

=SUM(HLOOKUP(J2,$E$4:$G$8,2,),HLOOKUP(J2,$E$4:$G$8,3,)*ROUNDUP((MIN($C$6,$K2)-1)/$D$6,),HLOOKUP(J2,$E$4:$G$8,4,)*ROUNDUP(MAX(,-$C$6+$K2)/$D$7,),ROUNDUP(L2/D8,)*HLOOKUP(J2,$E$4:$G$8,5,))
should be an exact match

this is awesome thanks!!!

Hi, I need to do the same question and i found the answer while searching but i do not quite understand the formula. Could someome explain to me