rounding numbers and =if statement

[mheinmiller]

I have a massive spreadsheet to manupulate. Long story short ...
I have 3 numbers that I have rounded and if they do not equal a certain number, i need 1 added .... the tricky part (for me) is that I need it added in a cell that is already rounded.
attached is an example, but here is the short version:

Number1 Number2 Number3 Total
5.2 6.4 9.4 21.0


5.0 6.0 9.0
nmb 1 rounded nmb 2 rounded nmb 3 rounded

If these 3 numbers do not add up to the total then I need 1 added to one of the numbers. How can I incorporate that into my =round formula?

[NBVC]

Assuming you can use G5 as the cell to change based on condition, then change formula in G5 to:

=ROUND(D2,0)+(SUM(E5,F5,ROUND(D2,0))<>F2)

[sailepaty]

Maybe this,

G5 =SUM(B2:D2)-SUM(E5:F5)

Regards