Forum Discussion
Solved
Help with an IF formula
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 t...
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))?
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))?
- Yes! This has worked, thank you so much!
Karly_ChubbyMealworms , you are welcome
