if else statement in excel code example
Example 1: 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"))
Example 2: if function example
var hi = "hi";
if (hi == "hi") { //if the variable hi is "hi" then:
//Whatever you want to happen
} if (hi != "hi") {
//Whatever you don't want to happen
}