IF & Logic
IF, IFS, SWITCH, AND and OR in Google Sheets: several conditions, partial text matches and whole-column formulas with ARRAYFORMULA, all tested.
-
IF with Multiple Conditions in Google Sheets: AND, OR, Nested IF and IFS
IF checks one condition and returns one value if it’s true and another if it’s false. Real decisions usually need more: pass only if the score and the attendance are…
-
IF a Cell Contains Text in Google Sheets (Partial Match)
To return something when a cell contains a word, not when it equals it, IF needs help from a function that searches inside text. The first thing most people try,…
-
ARRAYFORMULA with IF in Google Sheets: One Formula for the Whole Column
A normal IF formula works on one row, so you copy it down the column. ARRAYFORMULA lets a single formula in the top cell fill the whole column, and it…