=ROUNDUP(A2/6,0)*6

or

=CEILING(A2,6)

--
HTH

Bob Phillips

"GreenMonster" wrote in message
...
I need a function that rounds a number up to the nearest 6" increment

In other words, if the number to be rounded is 19" the value returned
would
be 24". If the number is 20" the value returned would also be 24".

To complicate matters, if the number to be rounded up is less than or
equal
to 2" then the the returned value needs to be then 2nd nearest 6"
increment.

In other words, if the number to be rounded is 17" or 16" then the
returned
value needs to be 24". 15" would round to 18", as would 14, 13, and 12.
10
and 11 would also round to 18".

Make sense? Hope so.

Thanks