Description | The |
Syntax | CEILING( |
Output | integer |
Variables
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 |