how do i round to the nearest 0.5
P Peo Sjoblom Apr 13, 2006 #2 =ROUND(Value/0.5,0)*0.5 -- Regards, Peo Sjoblom http://nwexcelsolutions.com
D daddylonglegs Apr 13, 2006 #4 =ROUND(A1*2,0)/2 or using MROUND from analysis toolpak add-in =MROUND(A1,0.5)
B bigred Apr 14, 2006 #5 works great thanks Domenic said: Try... =ROUND(A1/0.5,0)*0.5 Hope this helps! Click to expand...
