Ceiling Function In Excel
The excel ceiling function rounds a number up to a given multiple.
Ceiling function in excel. The ceiling and floor functions in excel are somewhat complimentary to the mod function. This function always rounds up to the significant number syntax ceiling number significance number. Here is what excel says about each.
If the number is already an exact multiple no rounding occurs and the original number is returned. The multiple to use for rounding is provided as the significance argument. The ceiling function in excel rounds up a number to a given multiple.
This article describes the formula syntax and usage of the ceiling function in microsoft excel. Ceiling number significance number a number. Mod returns a remainder after a number is divided by a divisor mod number divisor ceiling rounds a number up to the nearest multiple of significance ceiling number significance.
The sign much match the number. Significance the multiple to which to round the number. Number to be rounded up.
Ceiling function is very similar to the floor function in excel but the result is just opposite of the floor function where floor function gave us the result to the less significance ceiling formula gives us the result to the higher significance so for example if we have number as 10 and significance as 3 then 12 will be the result. A full list along with comparison tables is provided on the excel rounding functions page. The ceiling function is a built in function in excel that is categorized as a math trig function it can be used as a worksheet function ws in excel.
The function will return a number that is rounded up to a supplied number that is away from zero to the nearest multiple of a given number. It works similar to the mround function but the only difference is that ceiling always rounds up. Notice how the formula inputs appear ceiling function syntax and inputs.