This function returns the nearest Integer value which is greater than or equal to the number passed.
= CEILING(value)
Value |
A number whose ceiling value is to be calculated. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “CEILING(value): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= CEILING(-3.9) |
-3 |
= CEILING(3.9) |
4 |
= CEILING(“$1,234”) |
1234 |
= CEILING(“$-1,234.57”) |
-1234 |
= CEILING(UnitPrice) |
The ceiling of the value specified in the UnitPrice field |
= CEILING(“abcd”) |
Displays message “CEILING(abcd): Input string was not in a correct format.” |
= POWER(CEILING(UnitPrice), 2) |
The square of the ceiling value of UnitPrice. |
= MAX(CEILING(UnitPrice), 12) |
The maximum among the ceiling value of UnitPrice and the number 12. |