How do I get my formula to stop rounding up

[Guest]

My spreadsheet is set-up as follows:
Cell A3 = $3324.98
Cell C10 has $938,033.00
Cell D10 is =(C10/C$23) which is 7.59%
Cell C23 is the sum of column C which totals to $12,091,150.00
Cell E10 is =(D10*A3)
Cell E23 is =Sum(E10:E22)
The problem that I have is when the column for E10 is added up - it rounds
up a penny....my answer is always a penny more than it should be....I need it
to give the number without rounding.....I've tried going to Options and
choosing Precision as displayed but that changes all my numbers...any ideas?

 

[Guest]

Sheltie,

I suspect that you have a number of rounding issues. Have a look at
=round(). You can use it to choose where your rounding occurs.