How do I get my formula to stop rounding up
 

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?

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.

"SheltieGrl" wrote:

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?