Microsoft KB Archive/76290

= Works: Rounding Numbers in the Spreadsheet and Database =

Article ID: 76290

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q76290



SUMMARY
This article contains examples of ways to use the rounding feature in Microsoft Works for Windows.



MORE INFORMATION
The following is the syntax for the rounding feature:

=ROUND(value,number of places)

The &quot;value&quot; can be a number or a cell reference. The &quot;number&quot; of places can range from -14 to 14.

 Use the following syntax to round to the nearest integer:

=ROUND(23.4,0) equals 23

 Use the following syntax to round to the number of places to the left of the decimal point:

=ROUND(23.4,-1) equals 20 =ROUND(234.6,-2) equals 200

 Use the following syntax to round to the number of places to the right of the decimal point:

=ROUND(23.445,2) equals 23.45

 The following formula rounds the contents of cell A1 in a spreadsheet to the next higher integer:

=if((A1-INT(A1))=0,A1,INT(A1)+1)

 Use the following syntax to get the integer part of the number:

=INT(25.6) equals 25



Additional query words: 2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a w_works rounded round-off round off truncate up average

Keywords: kbinfo KB76290

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.