K klswvu Aug 8, 2003 #3 =MROUND(A1,0.5) --Rounds to the nearest 0.5 up/down ie 1.74=1.5 while 1.75=2.0 =A1-(MOD(A1,0.5)) --Rounds to the lowest 0.5 ie 1.74=1.5 while 1.99=1.5 KLS
=MROUND(A1,0.5) --Rounds to the nearest 0.5 up/down ie 1.74=1.5 while 1.75=2.0 =A1-(MOD(A1,0.5)) --Rounds to the lowest 0.5 ie 1.74=1.5 while 1.99=1.5 KLS
D dvt Aug 8, 2003 #4 Bradley said: I am needing a formula that will round down numbers to the nearest .5 Click to expand... =FLOOR(A1*2,1)/2 Dave dvt at psu dot edu
Bradley said: I am needing a formula that will round down numbers to the nearest .5 Click to expand... =FLOOR(A1*2,1)/2 Dave dvt at psu dot edu
