Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

ROUNDDOWN

Description: Rounds a number down, toward zero.

Syntax: ROUNDDOWN(Number, Num_Digits)

• Number is any real number that you want rounded down.

• Num_Digits is the number of digits to which you want to round Number.

Remarks:

• ROUNDDOWN behaves like ROUND, except that it always rounds a number down.

• If Num_Digits is greater than 0 (zero), then Number is rounded down to the specified number of decimal places.

Example:

• ROUNDDOWN(3.2, 0) = 3 [rounds 3.2 down to zero decimal places]