[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

 

[macropod]

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)

 

[Winny46]

Yay! Thank you. Knew it had to be easy....brain freeze. Those cents just would not work!! All is well now.