ROUNDUP

Rounds a number up to the nearest integer

Updated over a week ago

Description

The ROUNDUP() function rounds a given number up to the nearest whole number or integer. It's useful for scenarios where you need to ensure a minimum level or ceiling for values.

Syntax

ROUNDUP(number)

Output

integer

Variables

  1. number: The numeric value you want to round up to the nearest integer.

Example

ROUNDUP(`Price (USD)`)

Product

Price (USD)

Quantity Sold - NY

ROUNDUP

Product A

25.99

150

26

Product B

14.75

280

15

Product C

7.99

500

8

Product D

35.20

90

36

Product E

50.00

120

50

Did this answer your question?