We always order in half-dozens, and I need a formula that will:
#1: round to 6
#2: if the number is 1-2 from the integer divisible by 6, then round down
#3: if the number is 3-5 from the integer divisible by 6, then round up
(I know, terrible explanation)
For example if the value is...
12 - no rounding
13 - round down to 12
14 - round down to 12
15 - round up to 18
16 - round up to 18
17 - round up to 18
18 - no rounding
19 - round down to 18
20 - round down to 18
21 - round up to 24
etc.
Bookmarks