Microsoft KB Archive/65995

Works: Rounding Numbers in the Spreadsheet and Database

PSS ID Number: Q65995 Article last modified on 10-16-1998

1.05 2.00 3.00

MS-DOS

=
========================================================= 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

The following are examples of ways to use the rounding feature in Microsoft Works:

The following is the syntax:

=ROUND(value,number of places)

The “value” can be a number or a cell reference. The “number” 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.46   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 

Reference(s):

“Microsoft Works Reference.” Version 2.00. Pages 335, 326, 327.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Version : 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.