Spreadsheets are powerful because they can do more than just hold data. They can analyze it and make decisions based on rules you set. The foundation of this decision-making is logic. At its core, every logical question in Excel has a simple answer: TRUE or FALSE.

Is a sale amount greater than $1,000? Is a project due date in the past? Is a customer from California? These are all questions that produce a TRUE or FALSE result, which we can then use to trigger different actions.

Before building complex decisions, we need to understand the basic tools of logic. Excel has three key functions for this: AND, OR, and NOT.

AND checks if all conditions are true. Imagine you want to find employees who are eligible for a special bonus. The rule might be they need to have sales over $50,000 and have been with the company for more than 2 years. Both must be true for the outcome to be TRUE.

OR checks if at least one condition is true. For example, a shipping discount might apply if a customer is a new member or if their order is over $100. If either of those is true, the outcome is TRUE.

NOT simply reverses the logical value. If a cell contains TRUE, NOT returns FALSE, and vice-versa. This is useful for flagging anything that doesn't meet a certain condition, like =NOT(ISBLANK(A1)) to check if cell A1 is not empty.

The IF function is the workhorse of conditional logic in Excel. It takes a logical test and then performs one of two actions depending on whether the test returns TRUE or FALSE. It allows your spreadsheet to react dynamically to your data.

Let's apply this. Suppose we want to assign a pass/fail status to students based on their exam scores in column B. The passing score is 60. We can write a formula that checks if the score is greater than or equal to 60.

You can also combine the logical operators with IF. Let's revisit the bonus example. To get a bonus, an employee's sales (in B2) must exceed $50,000 and their tenure (in C2) must be over 2 years. We can use AND inside our IF statement's logical test.

What if you have more than two possible outcomes? For example, a grading system isn't just Pass/Fail; it's A, B, C, D, or F. For years, the standard way to handle this was by nesting IF statements. You place an IF function inside the value_if_false part of another IF function.

Here’s how you could assign grades based on a score in cell A2:

This formula first checks if the score is 90 or above. If it is, it returns "A". If not, it moves to the next IF statement to check if the score is 80 or above, and so on. This works, but it can get messy.

Fortunately, newer versions of Excel offer a cleaner solution: the IFS function. It's designed specifically for checking multiple conditions without nesting. The IFS function checks conditions in order and stops as soon as it finds one that is TRUE.

Let's rewrite the grading formula using IFS. It's much easier to follow.

Sometimes, your formulas will produce errors, like #DIV/0! when you divide by zero or #N/A when a lookup fails. These errors can be disruptive. The IFERROR function provides a simple way to handle them gracefully.

It checks if a formula evaluates to an error. If it does, IFERROR returns a value you specify. If not, it returns the result of the formula.

Imagine you are calculating a sales commission percent by dividing the commission amount (A2) by the total sales (B2). If a sale value in B2 is 0, the formula =A2/B2 would result in a #DIV/0! error.

Wrapping it in IFERROR cleans up the output.

Now that you understand how to build logic into your formulas, let's test your knowledge.

These logical functions are the building blocks for creating spreadsheets that are not just static reports, but dynamic tools that automate decisions and adapt to new data.