If any field is blank, symbol should be red

tbelly50

I'm trying to figure out how to write formula where, if any one of multiple fields is blank, the symbol is red, and if no fields are blank, symbol is green. Thanks!

Paul H

Try a nested If, something like this

=IF(ISBLANK(A@row), "Red", IF(ISBLANK(B@row), "Red", IF(ISBLANK(C@row), "Red", "Green")))

Paul H

Try a nested If, something like this

=IF(ISBLANK(A@row), "Red", IF(ISBLANK(B@row), "Red", IF(ISBLANK(C@row), "Red", "Green")))

tbelly50

Thank you!