Formatting
Excel Number Format: currency, thousands separator, decimals, negative in red
Excel number formats explained: currency, comma thousands separator, decimal places, percent, dates, and a custom format with negatives in red.
Author: Srini Vanamala
Formulas & Functions
Excel Subtract Formula: minus one cell from another
There is no SUBTRACT function in Excel — use the minus sign. Subtract two cells, a column from another, a fixed number, and dates.
Formulas & Functions
ROUND in Excel: to 2 decimals, to the nearest 10, up or down
ROUND in Excel: round to decimals, to whole numbers, to the nearest 10 or 100, always up or always down, and why formatting is not rounding.
Formulas & Functions
Excel LEFT Function: the first few characters of a cell
The Excel LEFT function: take the first N characters, everything before a dash or space, and turn the result back into a number.
Formulas & Functions
Excel IF with AND / OR: test two conditions at once
Combine IF with AND or OR in Excel: pass only if both conditions hold, or if either does, with a bonus example that uses both.
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.
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.
152 tutorials · Page 11 of 17
