SOLVED

Help with an IF formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2181869%22%20slang%3D%22en-US%22%3EHelp%20with%20an%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2181869%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formula%20to%20calculate%20a%20shipping%20price.%20If%20D14%20is%20less%20than%202000%2C%20show%202.99%20or%20if%20greater%20than%202000%20then%20show%204.99.%20OR%20if%20the%20price%20in%20cell%20L14%20is%20greater%20than%2024.99%20then%20show%200.00.%20I%20have%20tried%20this%20and%20a%20few%20other%20ways%20with%20no%20joy%20yet%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2181869%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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:

3 Replies
best response confirmed by Karly_ChubbyMealworms (New Contributor)
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))

Yes! This has worked, thank you so much!

@Karly_ChubbyMealworms , you are welcome