# Works: Rounding Numbers in the Spreadsheet and Database

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