Round numbers for new values mathematically

[light]

Hi

Column A is 107.4 and column B is 108.6. Total is 216. When I format Col A to its rounded number of 107, the answer is still 216 instead of 215.6. How do you tell excel that you want the rounded value in Col A to be calculated, not its true value.

[Sam Capricci]

you could try something like... =ROUNDDOWN(A2,0)+B2
that will return 215.6

or =ROUND(A2,0)+B2

[63falcondude]

Changing the formatting does not change the underlying value of the cell, only how that value is being displayed.

If you want to take the sum of a rounded value in column A , with the value in column B, you can do something like this:

=SUM(ROUND(A2),B2)

[light]

Thanks guys!