ƒxPlainFormulaThink in English. Formula in Excel.
PLAIN-ENGLISH FUNCTION DOCUMENTATION

Excel functions in plain English

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

SUMMath & Trigonometry

Adds numbers.

Read sentence and examples ↗
SUMIFMath & Trigonometry

Adds values that meet one condition.

Read sentence and examples ↗
SUMIFSMath & Trigonometry

Adds values that meet multiple conditions.

Read sentence and examples ↗
COUNTStatistical

Counts cells containing numbers.

Read sentence and examples ↗
COUNTAStatistical

Counts non-empty cells.

Read sentence and examples ↗
COUNTBLANKStatistical

Counts blank cells.

Read sentence and examples ↗
COUNTIFStatistical

Counts cells matching one condition.

Read sentence and examples ↗
COUNTIFSStatistical

Counts cells or rows matching multiple conditions.

Read sentence and examples ↗
AVERAGEStatistical

Calculates the arithmetic mean.

Read sentence and examples ↗
AVERAGEIFStatistical

Averages values that meet one condition.

Read sentence and examples ↗
AVERAGEIFSStatistical

Averages values that meet multiple conditions.

Read sentence and examples ↗
MAXStatistical

Returns the largest value.

Read sentence and examples ↗
MINStatistical

Returns the smallest value.

Read sentence and examples ↗
MAXIFSStatistical

Returns the largest value meeting conditions.

Read sentence and examples ↗
MINIFSStatistical

Returns the smallest value meeting conditions.

Read sentence and examples ↗
MEDIANStatistical

Returns the middle value.

Read sentence and examples ↗
MODE.SNGLStatistical

Returns the most frequently occurring value.

Read sentence and examples ↗
LARGEStatistical

Returns the k-th largest value.

Read sentence and examples ↗
SMALLStatistical

Returns the k-th smallest value.

Read sentence and examples ↗
ROUNDMath & Trigonometry

Rounds a number to a given number of digits.

Read sentence and examples ↗