Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
??? get "#NUM" doing 190^190
I cannot get 190^190 calculation in the excel.
The result is an #num. Would appreciate some advice -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
??? get "#NUM" doing 190^190
Excel cannot handle such a large number, type specifications into help and
calculation specifications and you'll see largest number you can type is 9.99999999999999E307, largest positive number allowed is 1.79769313486231E308 -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Jaylin" wrote in message ... I cannot get 190^190 calculation in the excel. The result is an #num. Would appreciate some advice -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
??? get "#NUM" doing 190^190
Thank you ver much for your advice.
I wonder if you would know how to fix it -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* "Peo Sjoblom" wrote: Excel cannot handle such a large number, type specifications into help and calculation specifications and you'll see largest number you can type is 9.99999999999999E307, largest positive number allowed is 1.79769313486231E308 -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Jaylin" wrote in message ... I cannot get 190^190 calculation in the excel. The result is an #num. Would appreciate some advice -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
??? get "#NUM" doing 190^190
I'm not Peo, but I read his response is not to use excel if you want that
number. Windows calculator returns this: 9.1872213705547406791477137556835e+432 Jaylin wrote: Thank you ver much for your advice. I wonder if you would know how to fix it -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* "Peo Sjoblom" wrote: Excel cannot handle such a large number, type specifications into help and calculation specifications and you'll see largest number you can type is 9.99999999999999E307, largest positive number allowed is 1.79769313486231E308 -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Jaylin" wrote in message ... I cannot get 190^190 calculation in the excel. The result is an #num. Would appreciate some advice -- Thanks a million for your time and expert advice :-) Jaylin *****Jaylin Message ended******* -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|