Microsoft KB Archive/23790

How to Truncate Decimal Numbers PSS ID Number: Q23790 Article last modified on 07-30-1987 PSS database name: D_MPlan

all

MS-DOS

Question: I want to truncate my values at the second decimal place so that all the less significant digits will simply drop off. I want 3.456 to turn into 3.45. How do I accomplish this in Multiplan?

Response: If you do not want to “round” the number but instead just have a “truncation” done, you should use the round function with a slight modification. As an example, suppose your first cell contains a value with more than two decimal places. Then in R2C1 we could put the formula round(R1C1-.005,2), then whatever the value is in R1C1, that value will be displayed in R2C1 truncated after the second decimal. If you want the value in R1C1 to be truncated to the second decimal place and displayed in that cell, you would have to edit that cell so that it looked like the following: round(34.456-.005,2).

Copyright Microsoft Corporation 1987.