Microsoft KB Archive/24720

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 3.0a, 4.0, 5.0, 5.0c
 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel 97 for Windows
 * Microsoft Excel for the Macintosh, versions 1.0, 1.03, 1.04, 1.06, 1.5, 1.5a, 2.20, 2.2a, 3.0, 4.0, 5.0, 5.0a
 * Microsoft Excel 98 Macintosh Edition

-

SUMMARY
To round a number to a set limit, use one of the following formulas.

Microsoft Excel 4.0 and Later
"=CEILING" Where is either a cell reference to the actual value to be rounded or a number to be rounded, and is the number to be rounded to.

For example, to round the number in cell A1 to the nearest .05, use the following formula:

"=CEILING(A1,.05)"

Microsoft Excel 3.0 and Earlier
"=ROUND( / ,0)*" Where is either a cell reference to the actual value to be rounded or a number to be rounded, and is the number to be rounded to.

For example, to round the number in cell A1 to the nearest .05, use the following formula:

"=ROUND(A1/.05,0)*.05"