Home

Using Boolean Expressions to Compare Values in Excel

Updated
2016-03-26 12:55:10
From the book
No items found.
Share
Microsoft 365 Excel For Dummies
Microsoft 365 Excel For Dummies book cover
Explore Book
Subscribe on Perlego
Microsoft 365 Excel For Dummies
Microsoft 365 Excel For Dummies book coverExplore Book
Subscribe on Perlego

To construct a Boolean expression, such as when you filter criteria, use a comparison operator and then a value used in the comparison: (>5, for example). These are Boolean comparisons that compare two values and evaluate whether the statement is true or false.

Comparison Operator What It Means
= Equals
> Greater than
>= Greater than or equal to
Less than
Less than or equal to
Not equal to

About This Article

This article is from the book: 

No items found.

About the book author:

Stephen L. Nelson, MBA, CPA, MS in Taxation, is a CPA in Redmond, Washington, where he provides accounting, business advisory, and tax planning and preparation services to small businesses. He is the bestselling author of 100-plus books about how to use computers to manage personal and business finances.

No items found.