Look up any Excel function — syntax, a real example, and when to use it.
Returns TRUE only if every condition given is true.
Returns one value if a condition is true, and another if it's false.
Returns a fallback value if a formula results in an error, otherwise returns the formula's normal result.
Returns a fallback value only if a formula results in the #N/A error specifically, otherwise returns the formula's normal result (including other error types).
Checks multiple conditions in order and returns the result for the first one that's true — a flatter alternative to nested IF statements.
Assigns names to intermediate calculations inside a single formula, so a repeated sub-calculation is written once and referenced by name.
Reverses a TRUE/FALSE value — turns TRUE into FALSE, and FALSE into TRUE.
Returns TRUE if at least one of the conditions given is true.
Compares one expression against a list of values and returns the result matching the first one found, with an optional default if nothing matches.