Table of Contents
The CEILING function in Google Sheets is a tool that allows users to round up a number to the nearest specified multiple. This function can be used by entering the desired number and the multiple you want it to be rounded up to. It is particularly useful for financial calculations, such as rounding up prices or quantities to the nearest dollar or whole number. This function is easy to use and can save time and effort in manual rounding calculations. By utilizing the CEILING function, users can ensure accurate and efficient results in their spreadsheets.
CEILING
The CEILING function rounds a number up to the nearest integer multiple of specified significance.
Sample Usage
CEILING(23.25,0.1)
CEILING(A2,1)
Syntax
CEILING(value, [factor])
value– The value to round up to the nearest integer multiple offactor.factor– [OPTIONAL:1by default] – The number to whose multiplesvaluewill be rounded.factormay not be equal to0.
Notes
When
valueis positive,factormust also be positive.When
valueis negative,factorcan be either negative or positive to determine which direction to round.CEILINGis most often used withfactorset to a “round” number, such as0.1or0.01,in order to round to a particular decimal place.
See Also
FLOOR: The FLOOR function rounds a number down to the nearest integer multiple of specified significance.
TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits.
ROUNDUP: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
ROUNDDOWN: The ROUNDDOWN function rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
ROUND: The ROUND function rounds a number to a certain number of decimal places according to standard rules.
MROUND: Rounds one number to the nearest integer multiple of another.
INT: Rounds a number down to the nearest integer that is less than or equal to it.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdGlTT3dybS1DckwyTk9kOFJtdVI3akE&output=html” width=”500″]