Formulas & Functions
Excel IF Cell Contains Text: flag rows with a word in them
Excel formula to check if a cell contains specific text, using ISNUMBER and SEARCH — case-insensitive, partial match, with a Yes/No result.
Category: Formulas & Functions
Formulas & Functions
Nested IF in Excel: three or more outcomes without the mess
Nested IF in Excel explained with a grade example, how to keep the brackets straight, and the IFS function that replaces it in newer Excel.
Formulas & Functions
IFERROR in Excel: hide #N/A and #DIV/0! errors
IFERROR in Excel wraps any formula and shows your own text or a blank instead of #N/A, #DIV/0! or #VALUE!. When to use it and when not to.
Formulas & Functions
Excel AVERAGE Formula: the mean, and averages that skip zeros
The Excel AVERAGE formula, why blanks and zeros give different answers, AVERAGEIF for one condition, and the median when one big number distorts the mean.
Formulas & Functions
IF Function in Excel: one result if true, another if not
The IF function in Excel with one example: pass or fail, then two conditions with AND, and several outcomes with nested IF or IFS.
Formulas & Functions
Excel MID Function: pull text from the middle of a cell
The Excel MID function with LEFT and RIGHT: extract characters from the middle, start, or end of a cell — product codes, area codes, years.
Formulas & Functions
TEXTJOIN in Excel: join a whole column with commas
TEXTJOIN in Excel joins a range of cells with any separator and skips blanks — the one-formula way to make a comma list.
Formulas & Functions
SUMIFS in Excel: add rows that match two or more conditions
SUMIFS in Excel: add sales for one person in one month, or amounts between two dates — several conditions, one formula.
Formulas & Functions
COUNTIF in Excel: count the cells that match
COUNTIF in Excel: count how many times a name appears, how many values are over a number, how many cells are blank or not.
29 tutorials · Page 2 of 4
