Using Logical Formulas in Excel

January 2017


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


Published by aakai1056. Latest update on September 27, 2016 at 02:33 PM by owilson.
This document, titled "Using Logical Formulas in Excel," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).