if else in excel code example

Example 1: if statement on excel

Simple If statement: 

=IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2)

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"))