Forum Discussion
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...
If you use a table and group the Boolean conditions applied to a single variable within array constants, the resulting formula is almost readable
= IF( AND(
OR( [@[Order Type]]={"DS","DT"} ),
AND( [@Class]<>{"FT10","FC10","TXTX","RSTK"} ) ),
-[@[Ext Price]],
0 )