long if function excel 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"))