Forum Discussion
IF statement not working on formula "0"
=IFS(A2="Product","Y", A2="sku","",AND(AE2="0",A2="rule"),"N",AND(NOT(AE2="0"),A2="rule"),"Y") Currently AE2 is a field with formulas that compute to 0, right now it is not recognizing this and ca...
I've also tried the permutation =IFS(A2="Product","Y", A2="sku","",NOT(AND(AE2="0",A2="rule")),"Y",AND(AE2="0",A2="rule"),"N")