•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Incremental rounding of data?
I'm rounding some outputs to be more "Human" numbers and would like to round differently depending on the magnitude.
For instance, 1.564 rounds to nearest .5 =>1.5
10.564 rounds to nearest 1 => 11
100.564 rounds to nearest 5 =>105
etc, etc. is there a clever way to do this without a bunch of nasty IF statements?
[link] [comments]
Want to read more?
Check out the full article on the original site