Hi,

I suspect the cell has converted the formula to text because of the dollar
sign. Format the formula cell as general and then re-enter this version of
your formula. You don't need the dollar sign even if your comparing currency
values.

=IF(J24<0,"WE OWE","OWCP OWES")

Mike

"mrsmmm1000" wrote:

I have a formula: =IF(J24<$0.00,"WE OWE","OWCP OWES") that only returns the
formula, not the result of the formula. The cell is a merged cell and is
formatted as General. Help!
--
lmcconaughy