• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Formulas returning -0- value when clearly there is a numerical answer. Help!

    I think that was it -- the workbook tree. Thanks so much!!!
  2. K

    Formulas returning -0- value when clearly there is a numerical answer. Help!

    Is there any other Automatic Calculation related setting besides (Tools - Options - Calculation)? It does seem like it's somehow related to this (even though I double-checked and I am in Automatic Calc mode). I say this because the formulas aren't recalculating when I make changes in the...
  3. K

    Formulas returning -0- value when clearly there is a numerical answer. Help!

    No, I checked and I'm in Automatic calc mode, and also, the formulas don't have the curly brackets (to indicate them originally being Array formulas, as mentioned above).
  4. K

    Formulas returning -0- value when clearly there is a numerical answer. Help!

    I'm using Excel 2003. We have a very complex spreadhseet that has been used by our company for years. When I open up one of these spreadsheets, if I click on a cell to check or edit the formula, and then press enter to get the updated value/solution, the solution goes to zero, whn that is...
Back
Top