Excel Tutorial – CEILING

The CEILING function in Excel allows you to round a number up to the nearest multiple of a specified number. This can be useful if you want to round a number up to the nearest whole number, or if you want to round a number up to the nearest multiple of a specific number.

To use the CEILING function, you will need to follow these steps:

1. Select the cell where you want the result of the CEILING function to appear.
2. Type “=CEILING(” (without the quotes) into the cell.
3. Specify the number that you want to round up. This should be a number or a reference to a cell containing a number.
4. Type a comma and then specify the multiple that you want to round the number up to. This should also be a number or a reference to a cell containing a number.
5. Close the parenthesis by typing “)”.

For example, if you wanted to round the number 3.4 up to the nearest whole number, you could use the following formula: “=CEILING(3.4, 1)”. This will return the result 4.

You can also use the CEILING function to round numbers up to other multiples. For example, if you wanted to round the numbers in the range A1:A5 up to the nearest multiple of 5, you could use the following formula: “=CEILING(A1:A5, 5)”. This will return an array of values consisting of the rounded numbers for each number in the range A1:A5.

I hope this tutorial has been helpful in understanding how to use the CEILING function in Excel.