Stefan
Stefan
Programming language:Whatever
2021-07-31 08:58:03
0
Q:

how to write ladder if else in exce

Shirley Li
Shirley Li
Code: Whatever
2021-08-09 10:38:23 
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"))
0

Tags

Related

New to Communities?

Join the community