Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculations work but cell shows '-' (Excel 2003)

    We have a cell that calculates interest and we can use the Audit toolbar's formula evaluation window to wathc the calculation done correctly, but when it finishes, we only see "-" in the cell because the cell suddenly evaluates to 0.000000. We get no error messages of any kind during the calculation. Any ideas? TYIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculations work but cell shows '-' (Excel 2003)

    Can you provide more detailed information and/or post a (sanitized) copy of the workbook?

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations work but cell shows '-' (Excel 2003)

    Will post one tomorrow-person needing help had to leave. The workbook includes Hyperion retrieve formulas to access that reporting database, but the formula in question is a simple =('Balance Sheet'!n$247*0.08)/365*N7 (a cell contining # of days). I've checked that the cells contain logical numbers not text numbers, and the formula does evaluate in the audit toolbar window, up until the last calculation step of multiplying by 31 days. At that point, the calculation goes to zero. We tried entering the 31 again as a number and it didn't change the result. Thanks.

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations work but cell shows '-' (Excel 2003)

    I noticed the workbook showed the cell in question as part of a circular reference issue. There were a number of cells cited in the informational window in the circular reference toolbar. Could their presence in the workbook "drive' the formula to zero somehow?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculations work but cell shows '-' (Excel 2003)

    Certainly - if the circular reference doesn't result in a converging value, Excel will display 0.

  6. #6
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculations work but cell shows '-' (Excel 2003)

    Ok, we will resolve the circular references and re-post if we have further problems. Thanks.

Posting Permissions

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