Sunday, March 4, 2012

How to get the first two decimal point of a sum in MS Excel without rounding it of?

Like for instance, the sum of a set of numbers is 10.246. If you will format it to two decimal places, typically, MS Excel will display 10.25. Without manually encoding the sum, what should I do to get only 10.24?How to get the first two decimal point of a sum in MS Excel without rounding it of?
Ok. Here goes.Once you have the final number eg: 10.246,

use this formula "=INT(Cell*100)/100" where "Cell" is the location of 10.246 on your Excel sheet. That's it!!How to get the first two decimal point of a sum in MS Excel without rounding it of?
Too lazy to look it up, probably involves truncation of the numberHow to get the first two decimal point of a sum in MS Excel without rounding it of?
Use the TRUNC worksheet function:



=trunc(sum(cell range),2)
The cell format function in MS Excel controls whether your final display has 2 decimal points or 3 or more... I just checked and don't see anywhere you can eliminate rounding that is built-in

No comments:

Post a Comment