D
Dan
I've created a spreadsheet where certain input values
seem to cause an incorrect value to appear in a cell.
The calculation result should display the calue of 90%,
but the cell shows a value of 168%. I have two other
cells that reference this cell: one shows the corerct
value of 90%, and the other shows 168%. This is really
weird - I've neve seen this before. Why is Excel showing
the wrong value?
I checking the calculation with my hand calculator, the
correct value is 90%. When I cut and paste "values" to
another cell, the number is the incorrect value of 168.
While the workbook does not report any errors or
unresolved circular references, this display error occurs
when a pick inputs that cause the maximum interations to
occur when the workbook calculates. I've not been able
to eliminate this problem with the specific input values
for which the error appears even though I've tried
various iteration combos of precision and number of
iterations.
Anybody have a clue on this? thanks!
seem to cause an incorrect value to appear in a cell.
The calculation result should display the calue of 90%,
but the cell shows a value of 168%. I have two other
cells that reference this cell: one shows the corerct
value of 90%, and the other shows 168%. This is really
weird - I've neve seen this before. Why is Excel showing
the wrong value?
I checking the calculation with my hand calculator, the
correct value is 90%. When I cut and paste "values" to
another cell, the number is the incorrect value of 168.
While the workbook does not report any errors or
unresolved circular references, this display error occurs
when a pick inputs that cause the maximum interations to
occur when the workbook calculates. I've not been able
to eliminate this problem with the specific input values
for which the error appears even though I've tried
various iteration combos of precision and number of
iterations.
Anybody have a clue on this? thanks!