This video demonstrates how to perform logical tests in Excel. Logical tests are central to using Excel's IF function. Download the featured file here https://excels-if-function.com/2020/02/20/writing-logical-tests-and-conditions-in-excel/

The logical tests demonstrated in this video use comparison or logical operators: greater than, less than, equal to and not equal to.

Also demonstrated is the use of information functions such as ISTEXT, IS NUMBER, ISERROR and ISBLANK. These information functions also perform logical tests.

Finally, the video looks at the AND, OR & NOT functions. AND and OR allow you to run multiple tests simultaneously. NOT allows you to easily convert a TRUE result to FALSE and visa versa.
------------------------