Rounding up and down to numbers divisible by 6

Excel 2007

All,

I am looking for a formula that will give take whatever number is in a specific cell and round it up or down (depending on closeness) to the nearest digit that is divisible by 6. For example:

If cell B3 contains the number 20, I would like it to return 18 in M3. If cell B4 contains the number 5, I would like it to return the number 6 in M4.

I am also looking to have a formula do the same thing, but instead of rounding up or down depending on closeness it would always round up. Like a general roundup formula except it finds the next highest number that is divisible by 6.

Any help would be greatly appreciated.

Thanks,
The Man With No Name

In cell M3 would be

Please Login or Register  to view this content.

This will round up or down to nearest multiple of 6.

In cell M4 would be

Please Login or Register  to view this content.

This will round up only to nearest multiple of 6.

I think this would do what you want.

shg & jjhayes,

These both work great. Thank you very much.