Shorter nested IF statements in Excel

November 27th, 2007 Posted in Programming, Tricks

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.

Post a Comment