View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.