You have the cell formatted as Text, so XL doesn't parse the entry as a
formula. Format the cell as General and reenter the formula.



In article ,
"SS" wrote:

In one case, the formula works beautifully. in the other case, the cell
spits back the formula. It does not give me the result. I seem to remember
having this problem before and pressing some combination of keys to get "{}"
to appear on either end of the formula and it working then, but I do not
remember the key combo.

Can anyone help? Why does this happen?