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...
If AE2 contains numeric zero, then the test should be AE2=0 without quotes around the zero.
And instead of NOT(AE2=0), simply write AE2<>0.