If formula problem
 

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

If formula problem
 

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

If formula problem
 

=IF(J24<0,"WE OWE","OWCP OWES") with no spaces before the =
--
Gary''s Student - gsnu200794


"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

If formula problem
 

It works with just a plain zero

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

"mrsmmm1000" wrote in message
...
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

If formula problem
 

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!

If formula problem
 

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!!
--
lmcconaughy


"Mike H" wrote:

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

If formula problem
 

Thanks.. it worked!
--
lmcconaughy


"Gary''s Student" wrote:

=IF(J24<0,"WE OWE","OWCP OWES") with no spaces before the =
--
Gary''s Student - gsnu200794


"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

If formula problem
 

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!
--
lmcconaughy


"Jim" wrote:

It works with just a plain zero

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

"mrsmmm1000" wrote in message
...
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

If formula problem
 

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!
--
lmcconaughy


"Graham H" wrote:

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!