Every formula,
made understandable.

Add numbers from cells or ranges.

Sum values that match one condition.

Sum values that match several conditions.

Count cells that match one condition.

Count rows that meet several conditions.

Average values that match one condition.

Multiply corresponding values and add the products.

Round a number to a chosen number of decimal places.

Calculate a total that responds to filtered rows.

Find a key in the first column and return another column.

Find a value and return its corresponding result.

Look across the top row and return a value below.

Return a value at a row and column position.

Return the position of a matching value.

Filter, group and summarize a range with query language.

Return only rows or columns that meet a condition.

Return one value when a condition is true and another when false.

Test multiple conditions and return the first matching result.

Replace any formula error with a fallback value.

Return TRUE only when every condition is true.

Return TRUE when at least one condition is true.

Match one expression against a list of cases.

Join several text values into one string.

Join text with a separator and optionally ignore blanks.

Break text into separate cells at a delimiter.

Remove leading, trailing and repeated spaces.

Extract characters from the start, end or middle of text.

Replace matching text inside a string.

Return the current date or current date and time.

Calculate whole days, months or years between dates.

Return the last day of a month before or after a date.

Add working days while skipping weekends and holidays.

Count working days between two dates.

Return a number representing the weekday of a date.

Calculate the periodic payment for a fixed-rate loan.

Calculate the future value of an investment.

Calculate net present value for periodic cash flows.

Estimate the internal rate of return for periodic cash flows.

Calculate straight-line depreciation per period.

Estimate return for cash flows on irregular dates.

Return unique rows from a range.

Sort rows in a range by one or more columns.

Apply a calculation across an entire range.

Create a sequential array of numbers.

Swap rows and columns in a range.

Import cells from another Google spreadsheet.

Retrieve current or historical market data.

Create a miniature chart inside one cell.