Function ROUNDUP

Rounds a number (away from zero) to a specified number of decimals

Usage

ROUNDUP(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
ROUNDUP(13)	(None)	13
ROUNDUP(13.1)	(None)	14
ROUNDUP(number)	number is -10.1	-11
ROUNDUP(3.14159265, 2)	(None)	3.15
ROUNDUP(11, -1)	(None)	20
ROUNDUP(10.03, -1)	(None)	20
ROUNDUP(-10.03, -2)	(None)	-100

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