Works: Rounding Numbers in the Spreadsheet and Database (76290)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 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 "value" can be a number or a cell reference. The "number" of places can range from -14 to 14.

  1. Use the following syntax to round to the nearest integer:

    =ROUND(23.4,0) equals 23

  2. 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

  3. 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

  4. 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)

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

    =INT(25.6) equals 25

Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB76290
©2004 Microsoft Corporation. All rights reserved.