Nested if statement not working, am I doing the formula wrong or is it not working correctly?

Michael Goodman

Hi all - I am trying to do a nested if statement for an approval chain but I can not get it to return a value different than #UNPARSEABLE. Can someone check my formula and tell me where I am going wrong?

=IF([Cell 1]@row = "No", "Rejected", IF([Cell 1]@row = "More Info Needed", "More Info Needed", IF([Cell 1]@row = "Yes", =IF([Cell 2]@row = "No", "Rejected", IF([Cell 1]@row = "Yes", =IF([Cell 2]@row = "More Info Needed", "More Info Needed", IF([Cell 1]@row = "Yes", =IF([Cell 2]@row = "Yes", "Yes", "")))))))))

Bassam Khalil

Hi @Michael Goodman 

Hope you are fine, please try the following formula:

=IF([Cell 1]@row = "No", "Rejected", IF([Cell 1]@row = "More Info Needed",
"More Info Needed", IF([Cell 1]@row = "Yes", "Yes")))