+ Reply to Thread
Results 1 to 3 of 3

#NUM! problem

  1. #1
    Registered User
    Join Date
    03-08-2017
    Location
    Louisiana
    MS-Off Ver
    Excel 2013
    Posts
    2

    #NUM! problem

    Im getting #NUM! for some cells. Why is that? Specifically for the cell M11.
    Attached Files Attached Files

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

    Re: #NUM! problem

    Using the Evaluate formula tool (https://support.office.com/en-us/art...6-a70aa409b8a7 ), I see that your formula in M13 is trying to take a negative number to a fractional power. You probably need to spend some time trying to decide if the "base" in this problem should be negative. If it is not, figure out what is wrong that is causing that part of the formula to be negative. If it is, then try to decide what (-1)^(5/6) means in the context of your problem. Then adjust the formula accordingly.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-08-2017
    Location
    Louisiana
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: #NUM! problem

    Thank you for helping

+ 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: 2
    Last Post: 10-21-2015, 02:36 AM
  2. [SOLVED] Excel Macro - Copy & Paste (Font) problem & Delete Last Added Rows problem
    By LennartB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2015, 06:58 AM
  3. Update Values problem and a Value Selection Problem----Please Help.
    By TrivialT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2013, 02:43 PM
  4. Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  5. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  6. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  7. Replies: 2
    Last Post: 01-22-2013, 07:09 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