CEILING function MS Excel

Q: What is the difference between Roundup and CEILING in Excel?

Roundup rounds a number up to the nearest value while CEILING rounds a number up to the nearest integer. For example, if a number is 5.2, Roundup would round it up to 6 while CEILING would round it up to 6.0.

Q: What is the difference between FLOOR and CEILING functions in Excel?

FLOOR is a function that rounds a number down to the nearest integer, while CEILING rounds a number up to the nearest integer.

What is CEILING function in Excel?

A CEILING function in Excel is a mathematical function that rounds a number up to the nearest integer, or to the nearest multiple of a specified value. It can also be used to round a number down to the nearest multiple of a specified value.

Description

The CEILING Function in Excel is an important mathematical tool that can be used to round numbers to a specified multiple.

For example, a user can enter a number and the function will round it to the nearest integer, nearest tenth, nearest hundredth, etc. depending on the user’s specified multiple.

It can also be used to round numbers up or down to the nearest multiple. For example, a user can specify that a number should be rounded up to the nearest multiple of 5. This is especially useful when working with large numbers or data analytics tasks.

Struggling with your Excel formulas?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free

CEILING Function Syntax

=CEILING(number, significance)

number: The number you want to round up.

significance: The multiple to which you want to round a number.

CEILING Function Example in Excel

CEILING function ms excel - excel formulas and functions

In our example you can see that we want to round the numbers in column J to the closest number.

Function Example Result in Excel

CEILING function ms excel - excel formulas and functions - result

In this screenshot you can see that function rounded to the biggest whole number.

Bonus Example

We added bonus example to show you that you can change significance number to round the number to the nearest 100 or 1000 or other number.

How to use CEILING function MS Excel in your workbook:

Open your Excel spreadsheet and identify the data that you wish to use for the ceiling function.
Select the cell in which you would like the result of the ceiling function to appear.
Enter the following formula in the selected cell: =CEILING(number, significance).
Replace the “number” part of the formula with the cell containing the data that you wish to use for the function.
Replace the “significance” part of the formula with the smallest integer that you want your result to be rounded to. For example, if you wish to round to the nearest 10, enter 10 in the formula.
Press Enter to calculate the result of the function. The result should appear in the selected cell.

Back to Excel Formula Cheat Sheet

Frequently Asked Questions

What is the difference between Roundup and CEILING in Excel?

Roundup rounds a number up to the nearest value while CEILING rounds a number up to the nearest integer. For example, if a number is 5.2, Roundup would round it up to 6 while CEILING would round it up to 6.0.

What is the difference between FLOOR and CEILING functions in Excel?

FLOOR is a function that rounds a number down to the nearest integer, while CEILING rounds a number up to the nearest integer.