7 lessons in order
The Google Sheets IF function is one of the most commonly used logical functions that helps you make decisions based on conditions. It allows you to create conditional logic in your spreadsheets performing one action if a condition is true and a different action if the condition is false. This function brings logic into your […]
Learn how to check for partial text in Google Sheets using SEARCH, REGEXMATCH, VLOOKUP, and more to easily match and count text.
Learn how to return a value in another cell if a cell contains text in Google Sheets using IF with SEARCH, EXACT, or REGEXMATCH functions.
Learn how to use the IF formula in Google Sheets with multiple conditions by combining IF with AND, OR, and using the IFS function.
Learn how to show 0 instead of blank in Google Sheets using IF, IFERROR, ISBLANK, ARRAYFORMULA, N function, or Apps Script for full control.
Learn how to return a value if a cell color is red in Google Sheets using Apps Script, conditional formatting with helper columns, or add-on.
Learn how to check if a cell is not empty in Google Sheets using IF, ISBLANK, COUNTA, LEN functions, conditional formatting & Apps Script.