+ Reply to Thread
Results 1 to 2 of 2

Exponential value for larger numbers

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    152

    Exponential value for larger numbers

    Hi,

    I have the following data

    A1 - 65.23
    A2 - 1923.52
    A3 - 945.18
    A4 - 182.54

    In column B

    B1 =exp(A1)
    B4 =exp(A4)

    both are fine, however

    B2 =exp(A2) - it is showing #NUM
    B3 =exp(A3) - it is showing #NUM

    Same case for all larger numbers

    Please let me know how to correct this.

    Thanks

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Exponential value for larger numbers

    There is a built-in numerical limit in Excel: (1.79769313486231E+308)

    =EXP(709) is just below that limit. Once you hit =EXP(710) it exceeds the limit and returns a #NUM error.

    - Moo

    Link to Excel's limitations

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-20-2013, 03:59 AM
  2. Replies: 2
    Last Post: 04-21-2010, 04:41 PM
  3. Converting exponential numbers
    By LAF in forum Excel General
    Replies: 3
    Last Post: 01-27-2010, 02:02 PM
  4. exponential numbers in cells
    By dick in forum Excel General
    Replies: 4
    Last Post: 06-27-2006, 06:10 AM
  5. Larger Numbers!!!
    By exsam21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2005, 04:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1