On May 22, 12:00*am, tjatja wrote:
there are bugs in microsoft exel 2007 for calculation of:
154,2 x 1700 = 262.140 if the result we divide by 4 equal to 100.000 and
then if we multiply again with 4 it's back to 262.140
and also if the result (262.140) we divide by 2 and than multiply again with
2 the result is 100.000
*or:
154,2 x 1700 = 262.140 / 4 = 100.000 x 4 = 262.140 /2 = 131.070 / 2 = 100.000

any comment? or do i have to use previous microsoft exel to avoid this bug?

Excel follows the rules of math which are it will do all steps inside
parenthases then it will do all multiplting then dividing then adding
then subtracting. Chek to make sure that the result that you want to
come up with is not breaking these rules.
Jay