Forum Discussion

cestrada's avatar
cestrada
Copper Contributor
Aug 30, 2019

Help with Excel using IF and AND and OR and NOT functions

Hi, I'm trying to write a formula that incorporates the IF function and uses the OR, AND and NOT features.   I want the formula to read:   IF cell G5="DS" or "DT" AND cell AF5 does not equal "FT10...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 30, 2019

cestrada 

That's like

=IF(AND(OR(G5="DS",G5="DT"),OR(AF5<>"FT10",AF5<>"FC10",AF5<>"TXTX",AF5<>"RSTK")),-S5,0)

if translate your text into formula

cestrada's avatar
cestrada
Copper Contributor
Aug 30, 2019

SergeiBaklan 

 

Thank you so much for your help, it works perfectly!

Resources