Imbedded If To Check For 3 Conditions

JiMel

A cell can be either 1)Approved 2)Pending Approval 3)Rejected

I'm struggling to find the error in my formula.

heyjay

Missing quotes.

=IF([Approval Status]@row = "Approved", "Approved",
IF([Approval Status]@row = "Pending", "Pending Approval", 
"Rejected"))

heyjay

Missing quotes.

=IF([Approval Status]@row = "Approved", "Approved",
IF([Approval Status]@row = "Pending", "Pending Approval", 
"Rejected"))

JiMel

Thank you, silly mistakes.