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...
and =IFS(A32="Product","Y", A32="sku","",AND(AE32="0",A32="rule"),"N",NOT(AND(AE32="0",A32="rule")),"Y")