Microsoft Office Tutorials and References
In Depth Information
The CEILING function returns a number rounded up, away from zero, to the nearest multiple
The NUMBER argument is the value you want to round, and the significance argument is the
multiple to which you want to round. For NUMBER arguments that are negative, use a negative
significance argument. Other wise, CEILING returns an error value. If a nonnumeric entr y is
made for either argument, CEILING returns an error value.
An interesting use for the CEILING function is in the adjustment of time periods. The
following formula uses the NOW function as the number argument and a fraction as the
significance argument as shown in Figure 10.8. =CEILING(NOW(),1/96) is the formula that returns
the date serial number corresponding to the time, rounded up to the next 15-minute period.
So, if the current time is 9:02 (and the cell containing this formula has a time number
format), this formula returns 9:15.
The number you want to round.
The multiple in which you want to round.
The CEILING function
with the NOW function
can be used to return
when formatted to a
The COMBIN function returns the number of combinations for a given number of items. Use
COMBIN to determine the total possible number of groups for a given number of items.
The number argument is the number of items.