Please, rate this answer

--
Rogerio Takejame
Americana - Sao Paulo - Brazil


"Lafayette" wrote:

Appreciate your reply. Your solution works pretty well.

"Rogerio Takejame" wrote:

It seams that the limit is 2^27-1 = 1.34 e8 but I don't know why. To avoid
the error, you can use =sin(mod(1.35 e8, 2 * pi()))

--
Rogerio Takejame
Americana - Sao Paulo - Brazil


"Lafayette" wrote:

sin() seems unable to handle a large number like 1.35 e8? Is anyone aware of
this type of computational limit? Thanks for related information