Excel FunctionsExcel CEILING Function

Excel Ceiling Function

Description

The Excel CEILING function rounds up any referred number to a multiple of the given number ( in the example of the above image it is 5).

Instead of following the general principle of rounding numbers, like ROUND and MROUND, this function rounds up to the nearest multiple of the given number. 

The Excel CEILING Function is different from the other rounding functions as this function rounds up to the multiple of a given number.

Whereas in the functions like ROUND, ROUNDUP and ROUNDDOWN a fraction is rounded to a given number of digits. 

=CEILING(number,significance)

The CEILING function’s syntax has the following arguments:

  • number Required.

This argument shall be the number (even stored as text) or reference to the number you want to round. In the example given in the image above the number “32” and the cell B3 (i.e. reference to the number) is our required argument.

  • significance Required.

The number of which the multiple is required.

AVANTAGEHeadquarters
Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
https://excel-accountancy.com/wp-content/uploads/2019/04/img-footer-map.png
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.