Hi,
Take the $ out of the formula and it should work

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

HTH
Graham

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!