IF & Logic

IF, IFS, SWITCH, AND and OR in Google Sheets: several conditions, partial text matches and whole-column formulas with ARRAYFORMULA, all tested.