I Am Excel User, Hear Me OR!


Meatloaf was on to something... "Now don't be sad... 'cause two outta three ain't bad!"

Sometimes when we're using conditionals in Excel, we don't need everything to come up roses; we just need ONE of our search terms to be TRUE and we're in business.

That's what OR is for!

Let's take the same two columns of numbers from yesterday.

But instead of an AND function, which returns TRUE only if every condition inside of it is TRUE, let's use an OR function.  In English,

"If either of the two numbers is greater than one, return 'AT LEAST ONE > 1'; otherwise, return 'ALL LESS THAN 1.'"

Need additional help with OR, IF, or other Excel elements?  Don't hesitate to reach out via live chat, email, or phone with your question and we'll answer in minutes!