G
Gary Keramidas
i'm wondering if there is a single formula that will round the following
examples in vba. i can do it with if statements, but looking for a more
compact solution to enter the value in a cell.
if it's < .5 it rounds to .5. if it's > .5 it rounds to the nearest .5.
4.571428571 5
0.571428571 0.5
0.575428571 1
0.285714286 0.5
0.214285714 0.5
57.03571429 57
examples in vba. i can do it with if statements, but looking for a more
compact solution to enter the value in a cell.
if it's < .5 it rounds to .5. if it's > .5 it rounds to the nearest .5.
4.571428571 5
0.571428571 0.5
0.575428571 1
0.285714286 0.5
0.214285714 0.5
57.03571429 57