Compute rounded values

[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

 

[Bob Phillips]

=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)

 

[Guest]

You rock. Thanks

vk

=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)