How to Use Logical Test in Excel and its 4 Benefits

This video shares with you how to use logical test in Excel.

Logical test is to check if something is true or false. There are mainly 4 benefits to it; Excel conditional formatting using formula (conditional formatting based on another cell), Excel IF function, Excel array formulas, and to do simple checks.

We are mainly going to concentrate on doing simple checks in this video and do the Excel conditional formatting using formula and Excel IF function in the next 2 videos. To do a logical test, you need to use any one of the operators. They are Equals, Greater than, Greater than or equals to, Lesser than, Lesser than or equals to, and Not Equals to.

A logical test can be as simple as:
=G2 GREATER THAN 25000
That is asking whether cell G2 greater than 25000? Excel will tell you if it’s TRUE or FALSE.If it is greater than 25000, it will return TRUE. if it’s not, it returns FALSE.

If you wish to compare it to a cell with text, you need to use double quotes. For eg:
=B2=”moonhub”
That is asking whether cell B2 is equals to the text “moonhub”. Again, it returns TRUE if it is equals to “moonhub” and FALSE if otherwise.

If you need to check multiple logical tests, you need to use the Excel AND function, or the Excel OR function. For eg, you can check if cell G2 is in between 25000 and 50000 by doing:
=AND(G2 GREATER THAN OR EQUALS TO 25000,G2 LESSER THAN OR EQUALS TO 50000)
All conditions must be met for the above to turn TRUE.

Or if you want to check if ANY one of the condition is TRUE, you can use:
=OR(C2 GREATER THAN 20,G2 GREATER THAN 20000)
as long as either cell C2 is greater than 20 OR cell G2 is greater than 20000, it returns TRUE.

Subscribe & press the bell to get notified!

Download file to follow along here:

Don’t find a tutorial to solve what you need. Watch all videos to be able to know what you don’t know.

#excelbear #excelinfotainment #excellogicaltest

Read more