Is there a way to round a number to the nearest .5 - ie .5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5 etc TIA
G Guest Feb 5, 2004 #1 Is there a way to round a number to the nearest .5 - ie .5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5 etc TIA
F Frank Kabel Feb 5, 2004 #2 Hi one way: =ROUND(A1*2,0)/2 or MROUND(A1,0.5) for the MROUND function you need the Analysis Toolpak installed HTH Frank
Hi one way: =ROUND(A1*2,0)/2 or MROUND(A1,0.5) for the MROUND function you need the Analysis Toolpak installed HTH Frank
G Guest Feb 5, 2004 #4 thanks. -----Original Message----- Hi one way: =ROUND(A1*2,0)/2 or MROUND(A1,0.5) for the MROUND function you need the Analysis Toolpak installed HTH Frank . Click to expand...
thanks. -----Original Message----- Hi one way: =ROUND(A1*2,0)/2 or MROUND(A1,0.5) for the MROUND function you need the Analysis Toolpak installed HTH Frank . Click to expand...
