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.'"