Formulas > =CEILING()
How to Use CEILING() in Google Sheets
Description
How To Actually Use CEILING() in Sheets
CEILING(value, [factor])
Try CEILING yourself
Use the CEILING function to round up the values in the range A1:A10 to the nearest multiple of 5. Place your formula in cell B1.
Hints (2)
-
Remember to specify the factor for rounding.
-
You can apply the formula to each cell in the range.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the CEILING() formula:
Generate a CEILING() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses CEILING(). 2 free AI generations, no signup. Members get unlimited use.
Generate a CEILING() formula