If you want to write a formula like this

=IF(A1>10 And A2<20,”In Range”,”Out of Range”)

then you are candidate for the AND() function. AND() and OR() have the same syntax, so I’ll use AND() for the example. The above formula seems like the natural way to write the IF test, but AND() works like every other function, that is, first the function name, then the arguments. The relevant portion of the above formula would look like this

AND(A1>10,A2<20)

AND() will return True if every argument evaluates True. If even one argument returns False, the whole function returns False.

OR() will return True if any of the arguments is True. Only if they’re all False, will the whole function return False.