IF statement not working on formula "0"

DirtyHippywrote:

=IFS(A2="Product","Y", A2="sku","",AND(AE2="0",A2="rule"),"N",AND(NOT(AE2="0"),A2="rule"),"Y")

That formula returns #N/A if A2 can be anything other then "Product", "sku" or "rule".  For example, can A2 appear blank (empty or the null string)?

It is prudent to always have a TRUE part at the end.  For example:

=IFS(A2="Product", "Y", A2="sku", "", A2="rule", IF(AE2=0,"N", "Y"), TRUE, "")

Aside....  A2="sku","" is superfluous if it is the same as the TRUE result, like mine.

Alternatively, if A2 can be only "Product", "sku" or "rule":

=IFS(A2="Product", "Y", A2="sku", "", TRUE, IF(AE2=0,"N","Y"))