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