Tech Support Forum banner

Excel 2003 - rounding ?

571 Views 2 Replies 2 Participants Last post by  Winny46
Can someone please tell me how I can make a simple addition of two cells using the values of each cell (each of which is a caclulated figure) instead of using the addition of the two calculations?

I am getting a (dollar) figure which is not correct due (I guess) to rounding within the calcuation. :sigh:

Thanks for any help

Winny
Status
Not open for further replies.
1 - 3 of 3 Posts
Hi Winny,

Your problem may be that the two cells you're summing are themselves only showing rounded-off values. When you sum such cells, the final result is based on the unrounded contents of the source cells. If that describes your problem, you can add a ROUND function to either:
. each of the source cells, so that what they hold is, in fact, the rounded-off value that's being displayed; or
. each of the expressions in the summing formula (eg =ROUND(A1,)+ROUND(A2,0) to return the sum of cells A1 & A2, each rounded off to the nearest whole number)
Yay! Thank you. Knew it had to be easy....brain freeze. Those cents just would not work!! All is well now.
1 - 3 of 3 Posts
Status
Not open for further replies.
Top