Not always up or always down!
B bpeltzer Feb 16, 2007 #2 With the Analysis Tool Pak add in you can use =mround(A1,0.5). Otherwise, I'd double the number, round, then divide by two: =round(2*A1,0)/2
With the Analysis Tool Pak add in you can use =mround(A1,0.5). Otherwise, I'd double the number, round, then divide by two: =round(2*A1,0)/2
H HaraldS Feb 19, 2007 #3 Thank you!!! This will help me! bpeltzer said: With the Analysis Tool Pak add in you can use =mround(A1,0.5). Otherwise, I'd double the number, round, then divide by two: =round(2*A1,0)/2 Click to expand...
Thank you!!! This will help me! bpeltzer said: With the Analysis Tool Pak add in you can use =mround(A1,0.5). Otherwise, I'd double the number, round, then divide by two: =round(2*A1,0)/2 Click to expand...
