PLAIN-ENGLISH FUNCTION DOCUMENTATION

Excel functions in plain English

Browse function explanations, sentence patterns, examples, and links to customise a query. Page 6 of 6.

Applies a calculation to each row.

Applies a calculation to each column.

Reduces an array to an accumulated result.

Returns intermediate accumulation results.

Creates an array using a LAMBDA.

Tests text against a regular expression in supported Microsoft 365 versions.

Extracts text matching a regular expression in supported Microsoft 365 versions.

Replaces regex matches in supported Microsoft 365 versions.

Rounds a number down to the nearest integer.

Multiplies corresponding array values and adds the results.