Thread
:
rounding to next 12th
View Single Post
#
2
JE McGimpsey
Posts: n/a
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.
Reply With Quote