nested if in excelle code example
Example 1: multiple if condition in excel
IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))
Example 2: how to write ladder if else in exce
So a simplified and working version of your formula would be:
=IF(ISERROR(FIND("abc",A1))=FALSE, "Green", IF(ISERROR(FIND("xyz",A1))=FALSE, "Yellow", "Red"))