Thanks to shg I got the first half of my challenge resolved in Round to Nearest Half Based On Defined Range of Decimal thread.

So here is what happens in the first half of the equation....I round numbers to the nearest half based on a specific range of decimals in the original number. For example if the number in A1 is:

28.0 to 28.399 then rounds DOWN to 28
28.4 to 28.799 then rounds to 28.5
28.8 to 28.99 then rounds UP to 29

for this I am using shg's equation:
=int(a1) + lookup(round(mod(a1,1), 6), {0,4,8}/10, {0,5,10}/10)
This is all I needed for most of my numbers.....but one part goes one step further.....

NOW THE SECOND HALF......Once the first half of the equation rounds the number above, I need the second half of the equation to then do the following. If the resulting number from the first part of equation above is:

  • 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)
  • 3.5 to 7 = 3
  • 7.5 and above = 4
  • Resulting number from last part of the formula multiply by 2

So this will end up being only 1, 1.5, 2, 2.5, 3, or 4 multipled by 2.

I am pretty sure this second part would be an IF statement (or maybe there is a more efficient way), but I am still learning the ins and outs of that....but I don't know how to use the first formula and add the needed second part into all one forumula.