Home

Using Boolean Expressions to Compare Values in Excel

|
Updated:  
2016-03-26 12:55:10
|
From The Book:  
No items found.
Excel Sales Forecasting For Dummies
Explore Book
Buy On Amazon

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.