Logical functions let a formula make decisions.
IF(condition, if_true, if_false) | one of two results |
IFS(cond1, value1, cond2, value2, …) | the first condition that holds; TRUE, "otherwise" is often added at the end |
AND(cond1, cond2, …) | TRUE if all conditions hold |
OR(cond1, cond2, …) | TRUE if at least one holds |
IFERROR(formula, replacement) | shows the replacement if the formula returns an error |
AND and OR usually go inside IF: =IF(AND(B2>1000, C2>=3), "yes", "no"). Empty text "" leaves the cell visually blank.