If statements

Hello Stacy

Thank you for your question.

The IF function always needs three parts to work, therefore because this formula is missing the value_if_false part, the formula won't work.

As you don't want Excel to put anything in the cell if L2 doesn't equal nm, then use:

=If(L2=nm, "red","")

The double quotation marks "" tell Excel to leave the cell blank if L2 does not equal nm.

Kind regards
Amanda