Round to nearest .125
Posted by Nick on January 11, 2001 10:09 AM
How can I round a NEGATIVE number to the Nearest .125
Posted by Mark w. on January 11, 2001 11:35 AM
To round away from zero use CEILING()...
=CEILING(-2.111111,-0.125) results in -2.125
To round towards zero use FLOOR()....
=FLOOR(-2.111111,-0.125) results in 2
