I have a bug in Numbers when I insert the formula
=SIN(RADIANS(180))
The result is:
0.000000000000000122464679914735 |
instead of exact 0.0
Can anyone reproduce the behaviour?
Or is this bug only on my Macs and iPads?
OS X El Capitan (10.11.3), Numbers 3.6.1
And here it is in Excel:
Because of floating point arithmetic precision problems, neither will give an exact 0.
That's not a bug, but a fact of life with computers.
Not sure why the result in Numbers is different from the result in Excel, though.😕
Use the ROUND function to make it 0.
SG
And here it is in Excel:
Because of floating point arithmetic precision problems, neither will give an exact 0.
That's not a bug, but a fact of life with computers.
Not sure why the result in Numbers is different from the result in Excel, though.😕
Use the ROUND function to make it 0.
SG
Apache OpenOffice:
LibreOffice
Google Docs spreadsheet:
That was a surprise!
Regards,
Barry
"Curiouser and curiouser!"
SG
Google Sheets:
SG
spotlight:
WolframAlpha:
SG
SG
😊 Doh!
Format defaults to far fewer decimal places. Of course.
Thanks,
Barry
MS Excel on Windows 7
When I was at school, (no jokes about Noah's Ark please) we used printed tables to look up log and trig functions, all with four decimal places. So 0.0000 was 0 and that was that!
Regards,
Ian.
I've heard that people used to do that.🙂 A slightly different problem, but I had a devil of a time with significant figures for measurements taken in lab. Never got it right.
The thing about the Noah's Ark business is that, being too young to understand these things myself, I just can't understand why two mosquitos were allowed on board.
SG
Hi Andre,
Thanks for the gold star! Keep posting in Apple Support Communities!
Hi SG,
being too young to understand these things myself
Hello youngster,
I just can't understand why two mosquitos were allowed on board.
They weren't invited on board. Like all parasites, they hitched a ride. Besides, wouldn't their larvae survive 40 days and 40 nights of rain? They were in their element!
Regards,
Ian.
SGIII,
Wolfram Alpha shows the wrong result 1.2236....*^-16 in the preview.
But when I tap the Open button, the result went to exactly 0 as your screen shot shows.
All of you,
thanks a lot for your answers. Its crazy for me that a lot of different software showing wrong results - even under Windows.
Certainly if you just want to know what is the result of sin(pi), this bug is not a real problem. But if you have complex formulas, using a mix of this trigonometric functions and other floating point and integer functions, this could be a real problem.
Another example:
30.1−30.09 ist what?
You think 0.01 ?
But Numbers say
0,0100000000000016 |
SIN(RADIANS(180)) bug in Numbers
