Limit of number which sin() can handle?
 

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

Limit of number which sin() can handle?
 

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

Limit of number which sin() can handle?
 

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

Limit of number which sin() can handle?
 

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