Using Logical Formulas in Excel

December 2016


When it comes to comparing data, Microsoft Excel uses what are called logical operations to make comparing data in sheets much easier. Often referred to as Boolean operators, these functions are used to compare data in spreadsheets and return absolute TRUE or FALSE statements based on the criteria.

This article will teach you how to use the greater than or equal to and less than or equal to formulas in Microsoft Excel.

Use the 'Greater Than' Formula

Let's take an example where you need to isolate any data entries that include values that are greater than 0 and less than 31.


Assuming that column B2 is your value cell, D2 is your formula cell, and any data points that fall in between that range should be marked with a Yes, your formula would look like this:

=IF(B2>0;IF(B2<31;"Yes";"No");"No") 

Use the 'Less Than' Formula

On the reverse side, you can also use these symbols to isolate data entries that include values that are less than 31 and greater than 0.


Assuming that column B2 is your value cell, D2 is your formula cell, and any data points that fall in between that range should be marked with a Yes, your formula would look like this:

=IF(B2<0;IF(B2>31;"Yes";"No");"No") 

Use 'Or Equal To' Formulas in Excel

If you'd like your formula to isolate any values that are greater than or equal to or less than or equal to a certain value, simply place the = sign next to the appropriate symbol as so:

<=

>=

Related :

This document entitled « Using Logical Formulas in Excel » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.