Compute rounded values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that is displaying values to the nearest 2 decimal
places. I'm dealing with money, so this is ideal. However, when I total
them, I'm getting a total that's a penny off since it's computing on the
entire value, not just the 2 decimal places that's displaying. Is there
anyway to tell my total to use the 2 decimal place number to compute rather
than the entire number. The only thing I saw on the help screen actually
replaced the formulas with values and I don't want to do that.

Thanks in advance for your help

Vivian
 
=SUM(ROUND(A1:A10,2))

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You rock. Thanks

vk

Bob Phillips said:
=SUM(ROUND(A1:A10,2))

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Back
Top