Mar 03 2021 07:10 AM
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:
Mar 03 2021 07:35 AM
SolutionWith "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))
?
Mar 03 2021 07:35 AM
SolutionWith "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))
?