CEIL

Rounds a number up to the nearest integer

Updated over a week ago

Description

The CEIL() 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

CEIL(number)

Output

integer

Variables

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

Example

CEIL(`Price (USD)`)

Product

Price (USD)

Quantity Sold

CEIL

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?