logical test

The IF formula is used to perform a logical test and return one value if the test is true, and another value if the test is false. To...

The AND formula is used to perform a logical test and return TRUE if all of the tests are true, and FALSE if any of the tests are...

The OR formula is used to perform a logical test and return TRUE if any of the tests are true, and FALSE if all of the tests are...