ROUNDDOWN

Rounds a number (toward zero) to a specified number of decimals

Usage

ROUNDDOWN(number, [num_digits])

Parameters

number	(Required) The number
num_digits	If zero or positive, the number of decimals to keep. If negative, the number digit to the left of the decimal point to turn to 0. Default is 0 which removes all decimals.

Examples

Example	With these variables	Result
ROUNDDOWN(13)	(None)	13
ROUNDDOWN(13.9)	(None)	13
ROUNDDOWN(number)	number is -10.9	-10
ROUNDDOWN(3.14159265, 4)	(None)	3.1415
ROUNDDOWN(19, -1)	(None)	10
ROUNDDOWN(19.54, -1)	(None)	10
ROUNDDOWN(-19, -1)	(None)	-10
ROUNDDOWN(-1234, -2)	(None)	-1200

Reminders

A text containing digits is not handled as a number. To have an actual number:

use the @NUMBER_QUESTION to set the variable
write a numeric value directly in the code without quotes, ex: age >= 18
use a function which converts to a number: NUMBER(text_containing_numbers)
use a function which returns a number: FIND("world", "hello everybody")

See also