B
bigred
how do i round to the nearest 0.5
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
D
Domenic
Try...
=ROUND(A1/0.5,0)*0.5
Hope this helps!
=ROUND(A1/0.5,0)*0.5
Hope this helps!
D
daddylonglegs
=ROUND(A1*2,0)/2
or using MROUND from analysis toolpak add-in
=MROUND(A1,0.5)
or using MROUND from analysis toolpak add-in
=MROUND(A1,0.5)
B