Problem with precision while adding parentheses

[jeouef]

Hi Guys

I'm performing really basics calculations in excel 2007, however, when I add parentheses at the beginning and end of a formula (which mathematically shouldn't change a thing), I get a precision error.

Here is what I mean
with: =C29-(C8-C14-((C8-C14-C19)/2))
I get 0.00000000000000000000000000000000000000000000000000

Now with : =(C29-(C8-C14-((C8-C14-C19)/2)))
I get 0.00000000000000022204460492503100000000000000000000 <table border="0" cellpadding="0" cellspacing="0" width="633"><colgroup><col width="633"></colgroup><tbody><tr height="20"> <td class="xl63" style="height:15.0pt; width:475pt" height="20" width="633" align="left">
</td></tr></tbody></table>Plz help, I guess it's a option thing, but I couldn't figure out any way of removing this error except the "set precision as displayed" which is not really convenient.

Thanks

 

[Gerald Higgins]

Hi, welcome to the board.

This looks like it might be a floating point problem, which is a recognised feature of Excel. Try doing a search on this board for "floating point".