Rounding traditionally to the nearest half is easy.....But I need to round numbers to the nearest half based on a specific range of decimals in the original number. For example if the number in D6 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
I am trying to do this without VBA if possible....
Thank you for any help and insights!
Bookmarks