What this category helps you do
Logical formulas help a spreadsheet make decisions. They are useful when a report needs to say whether a target was met, whether a row needs attention, or which label should be shown based on one or more conditions.
- Mark invoices as paid or overdue
- Create pass/fail labels for scores
- Flag rows that need review
- Build status messages for dashboards
Logical formula examples
Choose a formula below. Each page explains the formula in plain English and gives examples one at a time so long formulas are easier to read and copy.
AND
checks whether all conditions are true and returns TRUE or FALSE.
Open examples →FormulaCHOOSE
returns one value from a list based on a position number.
Open examples →FormulaFALSE
returns the logical value FALSE, often used in tests, flags, or exact-match settings.
Open examples →FormulaIF
tests a condition and returns one result when the condition is true and another result when it is false.
Open examples →FormulaIF AND
returns one result only when all listed conditions are true.
Open examples →FormulaIF OR
returns one result when at least one of the listed conditions is true.
Open examples →FormulaIFERROR
replaces any formula error with a cleaner value such as a blank, zero, or message.
Open examples →FormulaIFNA
replaces only #N/A errors while leaving other errors visible for review.
Open examples →FormulaIFS
checks several conditions in order and returns the result for the first true condition.
Open examples →FormulaLAMBDA
creates a reusable custom formula without VBA.
Open examples →FormulaLET
names parts of a formula so long calculations are easier to read and faster to edit.
Open examples →FormulaNOT
reverses TRUE to FALSE or FALSE to TRUE.
Open examples →FormulaOR
checks whether at least one condition is true and returns TRUE or FALSE.
Open examples →FormulaSWITCH
compares one expression against several possible values and returns the matching result.
Open examples →FormulaTRUE
returns the logical value TRUE, often used as a fallback or criteria flag.
Open examples →Best formulas to start with
How to learn this category
- Open one formula page and test the first beginner example.
- Change one cell reference at a time so you understand what each part controls.
- Check the common mistakes section before copying the formula down.
- Move to related formulas when you need a cleaner or more advanced version.