IFS and NOT BLANK

[lemery]

My formula is not working when fields are NOT BLANK.
I would like to have it say company append if Either column T or AM are NOT BLANK and A is 'highrisk' or 'mediumrisk' and I would like it to say unknown if both column T and AM are blank

 

[lemery]

Equals does not accept wildcards. A1="*" is true only if A1 contains exactly an asterisk.

This is helpful, thank you! Is this only for IFS or for all formulas?

 

[lemery]

try this

=IF(AND(ISBLANK(T20),ISBLANK(AM20)),"unknown",IF(AND((LEN(T20)+LEN(AM20))>0,OR(A20="highrisk",A20="mediumrisk")),"Company Append","X"))

What formula is LEN?
It's erroring when I try it.

 

[mikerickson]

This is helpful, thank you! Is this only for IFS or for all formulas?

This is for the = operator.
Most text functions (Mid, Find, etc) do not accept wildcards. Some, like COUNTIF, do. Use the Help system for details about a particular function.