To test if the value in A1 is between 5 and 10, you can use a formula like this: Logical tests in Excel formulas can be simple or quite complex, depending on the formula. Often, you will see several different logical tests in a single formula. In formulas that need to evaluate many cells at once, you will see logical tests that use Boolean logic. Here are a few examples of formulas based on logical tests:

If cell equals If cell is blank Cell contains specific text Cell contains one of many things


Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.