Format cell to display trunated decimal W/O rounding
Posted by Oscar Trevino on March 16, 2000 11:53 AM
How do I write a formula that will SUM a column of
numbers where each cell in said column contains
numbers that go out four decimal places, but that will
display the UNROUNDED result to only TWO decimal
places?
ie: 56.4167 displayed total = 56.41 NOT 56.42
Posted by judi on March 16, 2000 1:27 PM
The function you need is:
TRUNC(number,num_digits)
A sample formula would be:
=TRUNC(SUM(A1:A3),2)
Posted by Oscar on March 20, 2000 9:35 AM
Thanks, that worked!
