MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!