+ Reply to Thread
Results 1 to 7 of 7

unable to resolve a #NUM! error message

  1. #1
    Registered User
    Join Date
    11-10-2015
    Location
    Leesburg VA USA
    MS-Off Ver
    2010
    Posts
    2

    unable to resolve a #NUM! error message

    I have a column of cells using the nper function in them. They refer to cells in their respective rows. The cells referred to are input with numbers as $'s or % with no reference to other cells.

    A few of the cells in the column are returning the #NUM! Error, even though the others cells above and below are not. The problem cells are formatted exactly the same as the problem free cells.

    I have tried deleting the problem cells and re entering the formulas. I have tried re entering the numbers in the source cells, being sure that the format is the same as the cells above and below. Even tried using the formula in a cell outside of my table referring to the source cells in the problem row. That cell returned the #NUM! Error as well.

    Any solutions?

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,656

    Re: unable to resolve a #NUM! error message

    Welcome to the board.

    Post an example workbook.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: unable to resolve a #NUM! error message

    Quote Originally Posted by shg View Post
    Post an example workbook.
    ^ +1

    Or at least the formula, and example values..

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,031

    Re: unable to resolve a #NUM! error message

    What answer do you expect in those that are returning NUM? My first guess would be that something in the inputs in those cases causes the internal algorithm for the NPER() function to fail, and this error is Excel's way of saying that this combination of inputs does not yield an answer. If you can enter the same inputs into an alternative calculator and get a reasonable answer, then you may need to consider alternatives to the NPER() function. If you enter the same inputs into an alternative calculator and it returns an error as well, that would suggest that that set of inputs does not have a solution.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Registered User
    Join Date
    11-10-2015
    Location
    Leesburg VA USA
    MS-Off Ver
    2010
    Posts
    2

    Re: unable to resolve a #NUM! error message

    thanks Mr Shorty

    Did manual calc. NPER couldn't calculate amortization number because of negative amortization: interest carry was more than payment, so no amortization of principal could be calculated.

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,236

    Re: unable to resolve a #NUM! error message

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  7. #7
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,031

    Re: unable to resolve a #NUM! error message

    I am not financial analyst, but that sounds to me like the inputs were bad for those incidences of the function.

    Does that "resolve" the NUM error for you then, or is there still more to your question?

+ 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. Excel 2010 - Unable to Insert Column - Error message not helping
    By tplenert in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-25-2014, 05:36 AM
  2. [SOLVED] Unable to resolve #DIV/0! in sumproduct function
    By ruraljur0r in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2014, 09:57 AM
  3. Unable to resolve Runtime error 91
    By jr2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 07:37 AM
  4. error message - unable to save external link values
    By BitsofColour in forum Excel General
    Replies: 0
    Last Post: 10-04-2005, 03:05 PM
  5. Replies: 1
    Last Post: 02-07-2005, 05:06 PM
  6. Error message: Unable to record
    By Tim in forum Excel General
    Replies: 0
    Last Post: 01-26-2005, 03:25 PM

Tags for this Thread

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