Rounding Function referenced in another equation not yelding rounded answer

Hello All,
I hope someone can help. I found two threads (see links below) that seem to be asking the same question but the suggestion was to us the Rounding function, I have already done that and am having issues getting the answer to come out right.

I used the ROUNDUP function in a cell and when I reference it in another, it seams to treat it as a fraction.

Example:
ROUNDUP((B12+F12)*0.15,2) where B12=0 and F12=68.31, the cell equals 10.25. All Good!

Next cell referencing above Rounded cell:
Cell equals H42+L42+M42+AG45; where H42 is above rounded cell, L42 & M42 are H42/3*(-1), and AG45 is -5.25
It should equal -1.84
But surprise excel says it is -1.83

B12 F12 H24 L42 M42 AG45 Answer Cell
0.00 68.31 10.25 (3.42) (3.42) (5.25) (1.83)


Any suggestions as to how to get the right answer? Did I do something wrong or is this an issue with the program that needs to be fixed?
Much thanks.

Similar posts:
1.) Rounding of values then using in another equation http://www.excelforum.com/excel-gene...-equation.html

2.) Getting a formula to treat a fraction as a whole number http://www.excelforum.com/excel-gene...le-number.html

issue a round function on L42,M42 as well.

=round(H42/3*(-1),2)

Thank you vlady, that worked.
Can you explain why that would need to be rounded as well to get the right answer? So I know for the next time.
Thank you again for your help.

Hi and welcome to the forum

Unless H42 contains a value exactly divisible by 3, you are going to end up with a recurring decimal...1/3 = 0.333333... and 2/3 = 0.66666666.... so you need to round that too.

Also, you could simplify that slightly with...
=round(H42/-3*,2)

and this =round(H42/-3*,2) is equal to -3.416666667 not "-3.42"

thank Fdibbins

Vlad, didnt mean to "jump in" you looked like you were off-line and the OP was on-line, so I thought I would help out