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 then show 0.00. I have tried this and a few other ways with no joy yet:
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 Replies
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
