Works: Rounding Numbers in the Spreadsheet and Database

This article was previously published under Q76290
This article has been archived. It is offered "as is" and will no longer be updated.
SUMMARY
This article contains examples of ways to use the rounding feature inMicrosoft 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 placescan 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
2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a w_works rounded round-off round off truncate up average
Properties

Article ID: 76290 - Last Review: 10/07/2013 00:49:29 - Revision: 4.1

  • 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
  • kbnosurvey kbarchive kbinfo KB76290
Feedback