You already know how an IF statement works. It checks a condition and returns one value if it's true, and another if it's false. But real-world data is rarely that simple. What if you need to check three, four, or even more conditions at once? For that, we need to layer our logic.

One classic way to handle multiple outcomes is by nesting IF statements. A nested IF is an IF statement placed inside another IF statement. It lets you create a chain of decisions. The formula checks the first condition. If it's true, it gives a result. If it's false, it moves on to the next IF statement, which has its own condition to check.

This formula works, but you can see how it quickly becomes a tangled mess. Keeping track of all those parentheses is a common source of errors. Thankfully, there's a more elegant solution for modern spreadsheets.

The IFS function is designed specifically for checking multiple conditions in a clean, linear way. Instead of nesting, you just list your condition-result pairs one after another. The function checks each condition in order and stops as soon as it finds one that's true, returning the corresponding value.

Notice how much easier that is to read. There's no nesting, and each condition and its outcome are right next to each other. For the final catch-all condition (the 'F' grade), we simply state the remaining possibility: the score is less than 60.

Sometimes your decision depends on more than one factor at a time. You might need to know if all conditions are met, or if at least one is. This is where the AND, OR, and NOT functions come in. You can combine them with IF to build powerful business rules.

The AND function checks if all its arguments are true. For example, a sales bonus might depend on an employee exceeding their sales target and achieving a high customer satisfaction score. If either one is false, the whole AND statement is false.

The OR function is less strict. It checks if any of its arguments are true. A customer might get a discount if they are a new member or if their purchase total is over $100. Only one of those things needs to be true.

Finally, the NOT function simply flips a value from true to false, or false to true. It's useful for inverting a condition. For instance, you could flag all sales transactions that are NOT from your home country.

Your logical formulas can get complex, and sometimes they'll produce errors like #N/A or #DIV/0!. These are not only ugly, but they can also break other calculations that depend on that cell. The IFERROR function is your safety net.

Imagine you have a VLOOKUP that searches for a product ID. If the ID doesn't exist, VLOOKUP returns an error. By wrapping it in IFERROR, you can replace that ugly error message with something more useful, like "Product not found" or just 0.

This makes your spreadsheets more robust and user-friendly. Instead of a jarring error, the user sees a clear, helpful message you wrote yourself.

Ready to test your knowledge?

By combining these logical tools, you can automate complex decisions and make your spreadsheets react intelligently to your data.