Microsoft Office Tutorials and References

In Depth Information

**CEILING**

CEILING

The
CEILING
function returns a number rounded up, away from zero, to the nearest multiple

of significance.

=CEILING(number,significance)

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.

NUMBER

The multiple in which you want to round.

SIGNIFICANCE

Figure 10.8

The
CEILING
function

with the
NOW
function

can be used to return

15-minute increments

when formatted to a

time.

COMBIN

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.

=COMBIN(number,items)

The number argument is the number of items.