Tech Support Forum banner
Status
Not open for further replies.
1 - 3 of 3 Posts

·
Registered
Joined
·
2 Posts
Discussion Starter · #1 ·
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
 

·
Moderator , Microsoft Support, MS Office Pro
Joined
·
2,540 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)
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top