MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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