Learn how to return text from the middle of a text string.

Create formulas that include the greater than and less than symbols to get more out of criteria-based scenarios.

Rank items in a list.

Occasionally, Excel will return an error with functions and formulas. This might happen when you try to perform math functions on text,...

Learn how to translate language with a spreadsheet function.

Easily add up numbers based on one criterion (SUMIF) or multiple criteria (SUMIFS). The same functions can be used in Google Sheets as well.