Custom Rounding And IF Statement In One Formula....

Originally Posted by shg

=choose(match(int(a1) + lookup(round(mod(a1,1), 6), {0,4,8}/10, {0,5,10}/10), {0,3.5,7.5}), 2*int(a1) + lookup(round(mod(a1,1), 6), {0,4,8}/10, {0,5,10}/10), 6, 8)

SOOOOO Close. These two ranges work PERFECTLY!

• 3.5 to 7 = 3
• 7.5 and above = 4

But the first one "1 through 3 = its own size (1 is 1, 1.5 is 1.5, 2 is 2, 2.5 is 2.5, 3 is 3)" adds an extra .5 to the number if it is whole number and gives the wrong number when if the original number ends in .5 . And I cannot see why...