SIN(RADIANS(180)) bug in Numbers

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.