+ Reply to Thread
Results 1 to 4 of 4

Formula computes with the value of zero.

  1. #1
    Registered User
    Join Date
    11-18-2014
    Location
    Fredericton, Canada
    MS-Off Ver
    Home & Student 2010
    Posts
    2

    Formula computes with the value of zero.

    I have developed a few simple spread sheets, where one spreadsheet is a summary of values computed on different spreadsheets, and everything was working well. Now, a reference value comes back as zero on certain cells, even when there is real number referenced from the other spread sheet.
    Then at the same time, certain cells with formulas behind them compute to the value of zero, even with referenced cells from the same spread sheet.
    Any ideas what has happened here?

  2. #2
    Registered User
    Join Date
    03-31-2014
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Formula computes with the value of zero.

    You might have one or more circular references. Look at the bottom left. If you do, it should say so, and you can click on the 'Circular reference' notification to find the address of the most recent circular reference.

  3. #3
    Registered User
    Join Date
    11-18-2014
    Location
    Fredericton, Canada
    MS-Off Ver
    Home & Student 2010
    Posts
    2

    Re: Formula computes with the value of zero.

    Circular reference it was!
    It was obvious once I saw it.
    Thank you

  4. #4
    Registered User
    Join Date
    03-31-2014
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Formula computes with the value of zero.

    You're very welcome. If you are inclined, you can reward with an add to my reputation.

+ 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: 0
    Last Post: 08-14-2013, 10:34 AM
  2. Replies: 14
    Last Post: 06-02-2013, 03:08 PM
  3. Formula computes correctly, displays wrongly
    By Joseph Giri in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2013, 11:11 AM
  4. Replies: 7
    Last Post: 11-30-2012, 07:37 PM
  5. [SOLVED] Does anyone have a weekly schedule that computes total hours work
    By Guillermo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2006, 01:10 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