If formula problem

  • Thread starter Thread starter mrsmmm1000
  • Start date Start date
M

mrsmmm1000

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!
 
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
 
Hi,
Take the $ out of the formula and it should work

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

HTH
Graham
 
Thanks! It worked this time. I had tried with and without the $, with and
without the quotes around the true and false results before with no luck.
Thanks so much!!
 
Hi Jim! Thanks it worked this time! I have tried everything - just a plain 0,
with and without decimal point, with and without quotes in the true and false
- nothing worked. I guess it was just a loose screw behind the keyboard!
Thanks again!
 
Thanks! It worked! I had tried it that way before and it didn't - I guess
today the stars were aligned just right and it worked!! Thanks again!
 
Back
Top