G
Guest
Hello all,
I'm just doing some general adding, subtracting and some "IF" formulas etc.
in a worksheet. All was going great until I got to one sum and the formula
came back with "incorrect". Now, I've tried this on another colleague's pc
as well - in case I had a wrong setting, and it came up with the same answer.
The sum is the following (try it yourself!)
5012.10-5024.70
The answer should be -12.60, which is correct, but the formula showed
incorrect. It wasn't until I pressed F2 and then F9 I saw the complete
answer - which is -12.5999999999995. I know that it probably just rounded
the answer off somehow, but how did it find the answer?? I'm only using 2
decimal numbers.
Could this be a glitch?? I've tried different numbers which end in 12.10 and
24.70, but it works fine.
I'm just wondering how many other calculations are like this???
Thanks for your time
Aitch
I'm just doing some general adding, subtracting and some "IF" formulas etc.
in a worksheet. All was going great until I got to one sum and the formula
came back with "incorrect". Now, I've tried this on another colleague's pc
as well - in case I had a wrong setting, and it came up with the same answer.
The sum is the following (try it yourself!)
5012.10-5024.70
The answer should be -12.60, which is correct, but the formula showed
incorrect. It wasn't until I pressed F2 and then F9 I saw the complete
answer - which is -12.5999999999995. I know that it probably just rounded
the answer off somehow, but how did it find the answer?? I'm only using 2
decimal numbers.
Could this be a glitch?? I've tried different numbers which end in 12.10 and
24.70, but it works fine.
I'm just wondering how many other calculations are like this???
Thanks for your time
Aitch