Sintassi
CEILING(number, multiple)
- number—The number to round
- multiple—The nearest multiple of significance in which to round. Numbers with up to five decimals are allowed.
Utilizzo esempio
CEILING([Price Per Unit]1, 2)
Utilizzo note
If you want to round a number up to a specified number of decimal places, use ROUNDUP.
Esempi
Example 1
You are collecting the minutes spent on a task, but for billing purposes, it needs to be in multiples of 15 minutes. You can use CEILING to round up the exact time duration to a multiple of 15.
=CEILING([Meeting Length]@row, 15)
Example 2
You have a list of products with their Normal Price and available Discount percentages to create a Discount Price. The Final Price for the item must be a multiple of 0.25. You can use CEILING to round the calculated Discount Price to the next acceptable value to produce the Final Price.
=CEILING([Discount Price]@row, 0.25)
Example 3
You collect orders for individual products that must be ordered by the case. The quantity of items in each case varies. You can use CEILING to round up the Total Ordered to the next multiple of Case Quantity and then determine the total number of cases needed.
=CEILING([Total Ordered]@row, [Case Quantity]@row) / [Case Quantity]@row
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.