Works: How to Truncate Numbers in Works Without Rounding

To truncate numbers without rounding in a Works for Windows spreadsheet or database, use one of the following formulas where <Value>, <Cell Reference>, or <Fieldname> is the number to be truncated. <Digits> is the desired number of places to the right of the decimal point.

NOTE: The caret ^ (SHIFT+6) is the exponential operator.

EXAMPLE

To truncate the number 12.34567 to two digits in a spreadsheet, do the following.

1. Create a new Spreadsheet.
2. In cell A1, enter the number 12.34567.
3. In cell B1, enter the formula =INT(A1*10^2)/10^2.

The value in B1 is 12.34. Note that the value did not round to 12.35.

Works for Windows has a Round() function that will round a number to a specific number of digits. To truncate the number without rounding, the formula above must be used. For example, rounding the number 123.456 to two significant digits equals 123.46, while truncating equals 123.45. Truncating can be useful when you want to avoid errors in calculations caused by rounding.