Works: Rounding Numbers in the Spreadsheet and Database

Article translations Article translations
Article ID: 76290 - View products that this article applies to.
This article was previously published under Q76290
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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

Properties

Article ID: 76290 - Last Review: October 7, 2013 - Revision: 4.1
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
Keywords: 
kbnosurvey kbarchive kbinfo KB76290

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com