Shorter nested IF statements in Excel

By Ryan
Picture of the author
Published on

This code checks to see if A1 equals the letters K, H or L.

Instead of using =IF(A1="K",TRUE,IF(A1="H",TRUE,IF(A1="L",TRUE,FALSE)))

You can use =IF(OR(A1="K",A1="H",A1="L"),TRUE,FALSE)

As you can see, it's a lot shorter and makes a lot more sense. Especially if you need to add more to it in the future.

HomeAboutArticlesProjectsReviews