Hi,
I have a very weird problem in Excel which I hope someone can help me with.
When I use the following formula: "=SUM(ABB151:ABB154)-ABB140" I get zero (I.e "-" instead of "0" with one decimal. But when I use this: "=SUM(ABB140-SUM(ABB151:ABB154))" I get very close zero, but when I multiply the latter with "10000000000" I get 0.0027 which I don`t understand. I have tried two other formulas using IF and MAX before typing the above and also there I get either zero or close to zero.
Is this some kind of Excel bug that sometime excel automatically rounds after numerous decimals and sometimes not? Anyone familiar with this? I am just afraid that this is a problem on other formulas where I have not been able to implement control functions to check that everthing is correct.
Bookmarks