| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| expand number of rows from limit of 65,536? | Excel Discussion (Misc queries) | |||
| How do I increase the limit on the number of import rows in Excel | Excel Discussion (Misc queries) | |||
| Is there a limit to the number of worksheets in an excel file? | Excel Discussion (Misc queries) | |||
| How do I limit number of rows and columns on a spreadsheet | New Users to Excel | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
