Skip to main content
CEILING

Rounds a number up to the nearest integer

Updated over 4 months ago

Description

The CEILING() function rounds a given number up to the nearest whole number or integer, regardless of the decimal portion, effectively moving it toward positive infinity if positive, or negative infinity if negative.

Syntax

CEILING(number)

Output

integer

Variables

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

Example

CEILING(`Price (USD)`)

Product

Price (USD)

Quantity Sold

CEILING

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?