??? get "#NUM" doing 190^190

J

Jaylin

I cannot get 190^190 calculation in the excel.

The result is an #num. Would appreciate some advice
 
P

Peo Sjoblom

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
 
J

Jaylin

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 said:
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
 
D

Dave Peterson

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
Thank you ver much for your advice.

I wonder if you would know how to fix it
 
Top