ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / MATH & TRIGONOMETRY

ROUNDDOWN Excel function

Rounds toward zero.

Correct sentence to use

Round [number] down to [digits] decimal places.

Modify this query in PlainFormula →

Example formula

=ROUNDDOWN(A2,2)

Rounds toward zero.

Syntax

ROUNDDOWN(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