Hello, Im creating price table for my exam in transport logistics.
For now the formula is as follows:
=IF(I3*$R$16<$R$15,$R$15,I3*LOOKUP(I3,$Q$17:$R$20))
Where "I3" is the amount needed to send

and Q15:R20 is the price list

Minimal order sum is 110 (R15)
Nominal price is 19 (R16)
Price if amount is in range from 45 to 100 is 17 (R17)
100 to 200 is 15 (R18)
200 to 300 is 13 (R19)
and above 300 is 11 (R20)

My problem is, for example, if the amount is 195 it costs 2925€, in which case i would like to use next range's minimal cost which is 2600€.
How do i implement this is my formula ?
I really need help.
Thanks in advance, Alex