Menu
EXCEL CEILING FUNCTION
Excel CEILING Function Introduction
This method takes an integer and rounds it up to the nearest multiple provided, returning a rounded number.
Description of Excel CEILING Function
Syntax:
=CEILING (number, significance)
Parameter list:
- number – the number you wish to round to the nearest whole number.
- significance – the number you wish to round to.
Step By Step Guide of CEILING Function
Here in the given example, as you can see:
=CEILING(F6) returns round up 124.5 as 125 and so on.
Key Points
- CEILING returns the #VALUE! error value if either parameter is nonnumeric.
- When a value is moved away from zero, it is rounded up regardless of the sign of the integer. There is no rounding if the number is an exact multiple of significance.
- The value is rounded down, away from zero, if the number is negative and the significant is negative.
- If the number is negative and the significance is positive, the value is rounded up to the nearest tenth of a decimal place.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
