calculation error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My friends and I are modelling a simulation using VBA in Excel, with the
majority of the calculations carried out in the workbook (a total of 92
worksheets..) In one of the cells in sheet A, we use the formula :
=min(cell in sheet B, cell in sheet C).
The 2 cells contain a formula each, but the final answers are 0 and 0.77
respectively. Thus, if everything goes well, we should obtain 0 from the
formula above.
However, this cell churns out abnormal results. It gave us a negative value
once, and after we activated the re-calculation for the whole wookbook, it
showed 0.31, even though the 2 referenced cells maintained their values all
along.

Is this a limitation of Excel (because we have too many rather heavy
calculations)? If not, what could be the problem?
 
The 2 cells contain a formula each, but the final answers are 0 and 0.77
respectively.
Click to expand...

Are you sure that formatting isn't simply displaying a result of 0.31 as 0?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
Scrabble Value calculation for Welsh words 0
Time Sum in Excel 1
Vlookup and return sheet name also 2
Excel Average dates help 0
Counting # of Formulas in a column with formulas and entered data 1
Calculation Question 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Back
Top