yep, jim's seems to work fine

--


Gary


"Bob Phillips" wrote in message
...
I must admit to not having understood that other part, but it seems you
did.

Bob

"Jim Thomlinson" wrote in message
...
Give this a try to round cells in B1

=IF(MOD(B1, 6)=4, B1+12-MOD(B1, 6), B1+6-MOD(B1, 6))
--
HTH...

Jim Thomlinson