ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / MATH & TRIGONOMETRY

ROUND Excel function

Rounds a number to a given number of digits.

Correct sentence to use

Round [number] to [digits] decimal places.

Modify this query in PlainFormula →

Example formula

=ROUND(A2,2)

Rounds to the specified number of digits.

Syntax

ROUND(number, num_digits)

Argument signature: number, num_digits

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions