+ Reply to Thread
Results 1 to 4 of 4

value not showing in the result column

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    qatar
    MS-Off Ver
    Excel 2007
    Posts
    18

    value not showing in the result column

    Hi,

    In the attached file column M & P formulas not showing any results, i column link values to be considered in the result column, please assist for the same.

    Thanks,
    JD.Nethaji
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: value not showing in the result column

    Please check your formulas, they have circular references so it will never work.
    A circular reference refers to itself which will not work.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    08-02-2012
    Location
    qatar
    MS-Off Ver
    Excel 2007
    Posts
    18
    Quote Originally Posted by Keebellah View Post
    Please check your formulas, they have circular references so it will never work.
    A circular reference refers to itself which will not work.
    But in column N has value of M column+duration of that activity, results showing also zero, please assist in formulas. Thanks.

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: value not showing in the result column

    There is still a circular reference in your formula somewhere along the line you made a mistake, You know what you're trying to do. I don't.

    See the attached thumbnail
    Attached Images Attached Images
    Last edited by Keebellah; 11-10-2015 at 05:24 PM. Reason: added info

+ 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. [SOLVED] Help. Column showing same result no matter what the referenced cell's value.
    By swiftrain in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-01-2014, 08:57 AM
  2. Formula not showing exact result
    By karthikgmk in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-10-2014, 03:04 AM
  3. Why is it showing the false result?
    By jbearnolimits in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-20-2013, 01:46 AM
  4. Formula Result not showing
    By cemont in forum Excel General
    Replies: 8
    Last Post: 03-02-2012, 12:29 PM
  5. #NUM! and #VALUE Showing as Result
    By ltmaiyk in forum Excel General
    Replies: 4
    Last Post: 02-02-2010, 04:53 PM
  6. Formulae showing instead of result
    By bradikus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2005, 11:58 PM
  7. Formula result not showing up
    By DrewM in forum Excel General
    Replies: 2
    Last Post: 01-12-2005, 11:19 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