The formula is a very complicated "mega formula" involving many levels of
named formulas containing array formulas. The cell formula I was refering to
was array-entered so that's not the problem. The formula was evaluating
properly until I added a 5th level to the nested IF statements. The formula
has been copied down a column and the first 3 rows evaluate correctly, but
from the 4th row on, the value displayed is the same as row 3, when it should
be a different value (the one showing in "Funtion Arguements" dialog box
(see original posting)). Even more puzzling, is that the 5th level in the
nested IF statement shouldn't really be causing a problem, since the formula
evaluates to TRUE at the 3rd nested IF statement and the 5th level would not
even be evaluated unless the 3rd level evaluated to FALSE.
Could it be that my computer doesn't have enough RAM (512MB)?

"JE McGimpsey" wrote:

Depends on the formula. Why don't you tell us what it is...? And you
probably ought to let us know what the "correct" result and the "wrong"
result are, as well.

One cause could be that the formula needs to be array-entered (with
CTRL-SHIFT-ENTER or CMD-RETURN). There are others.




In article ,
"Brett" wrote:

Does anyone know what it means when a cell containing a formula, displays a
result that is wrong, but the correct value shows in the "Function
Arguements" dialog box near the bottom where it says "Formula result ="?