Help with an IF formula

[Karly_ChubbyMealworms]

Hi, 

I am trying to create a formula to calculate a shipping price. If D14 is less than 2000, show 2.99 or if greater than 2000 then show 4.99. OR if the price in cell L14 is greater than 24.99 then show 0.00. I have tried this and a few other ways with no joy yet:

[#2 · Accepted solution]

@Karly_ChubbyMealworms 

With "If D14 is less than 2000, show 2.99 or if greater than 2000 then show 4.99. OR if the price in cell L14 is greater than 24.99 then show 0.00." do you mean

=IF(L14 > 24.99, 0, IF( D14 < 2000, 2.99, 4.99))

? 

[#3]

Yes! This has worked, thank you so much!

[#4]

@Karly_ChubbyMealworms , you are welcome