Extracted Data Version
Overview
Grammar | CEILING(number) | Rounds up the number parameter to the nearest integer larger than or equal to its absolute value. |
Parameter | number | Number to be rounded up. |
Notes
The function supports only one number and returns illegal if more than one numbers are set.
Example
| Formula | Result | Notes |
|---|---|---|
| CEILING(-2.5) | -3 | |
| CEILING(0.5) | 1 |
Direct Connect Data Version
Overview
Grammar | CEILING(number) | Rounds the number parameter to the nearest integer larger than or equal to its value. |
Parameter | number | Number to be rounded up. |
Notes
The function supports only one number and returns illegal if more than one numbers are set.
Example
| Formula | Result | Notes |
|---|---|---|
| CEILING(-2.5) | -3 | |
| CEILING(0.5) | 1 |
