Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculation error
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? |
#2
|
|||
|
|||
The 2 cells contain a formula each, but the final answers are 0 and 0.77
respectively. Are you sure that formatting isn't simply displaying a result of 0.31 as 0? -- George Nicholson Remove 'Junk' from return address. "happyearth" wrote in message ... 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? |
#3
|
|||
|
|||
Indeed.. Thanks.
"George Nicholson" wrote: The 2 cells contain a formula each, but the final answers are 0 and 0.77 respectively. Are you sure that formatting isn't simply displaying a result of 0.31 as 0? -- George Nicholson Remove 'Junk' from return address. "happyearth" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Calculation Error for formula to sum | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
error in simple calculation? | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Percentage calculation error | Excel Discussion (Misc queries) |