|
??? 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******* |
??? 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******* |
??? 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******* |
??? 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 |
| All times are GMT +1. The time now is 05:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com