Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jaylin
 
Posts: n/a
Default ??? 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default ??? 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jaylin
 
Posts: n/a
Default ??? 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default ??? 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"