Learn How to Use Microsoft Excel CEILING Function

Microsoft Excel CEILING Function

The main function of the Microsoft Excel CEILING function is to round up a number to the nearest multiple. So, with the help of the CEILING function, you can able to round up the number to the nearest specified multiple. The function CEILING function is same as the MROUND function, but the CEILING function always rounds up. So, with the help of the Microsoft Excel CEILING function, you can easily round up the number to the nearest multiple.     

Return Value of CEILING Function

The return value will be the rounded number.

Syntax of CEILING Function

=CEILING(number, significance)

Where the arguments:

• number: This is the number you want to round up.
• significance: This is the multiple used while rounding up the number.

How to Use Microsoft Excel CEILING Function?

Microsoft Excel CEILING function is used to round up a number up to a given multiple. The multiple to use for rounding is provided as the argument while using the function. If the number is already an exact multiple, no rounding occurs and the original number is returned. The function CEILING function same as the MROUND function, but the CEILING function always rounds up. So, with the help of the Microsoft Excel CEILING function, you can easily round up the number to the nearest multiple.     

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel