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)
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)