rounding to next 12th
 

Hi:

I can't seem to locate the function that round a number in the next cell to
the next number divisible by 12 (eg if 25 is typed into cell A1, the formula
in A2 should come up with 36). It must always round up (not to the nearest).

Thanks.

one way:

=CEILING(A1,12)

In article ,
"Amie Barnes" <Amie wrote:

Hi:

I can't seem to locate the function that round a number in the next cell to
the next number divisible by 12 (eg if 25 is typed into cell A1, the formula
in A2 should come up with 36). It must always round up (not to the nearest).

Thanks.