IF cell has data in it

  • Thread starter Thread starter RayD
  • Start date Start date
Your formula is not structured properly.

It says........IF, "there is any value in cell H6", THEN "cell J6 is greater
than 1", OTHERWISE "make the cell blank"...........

If you post back with a TEXT version of what you actually want, someone will
give you a formula.

Vaya con Dios,
Chuck, CABGx3
 
Thanks for the reply

What I would like to do is: If cell(s) H6 or J6 have any number in it
(only one of the cells H6 or J6, will have a number in it, not both)
than put that value in the cell, other wise stay blank. Hope this
helps..

Ray

Your formula is not structured properly.

It says........IF, "there is any value in cell H6", THEN "cell J6 is greater
than 1", OTHERWISE "make the cell blank"...........

If you post back with a TEXT version of what you actually want, someone will
give you a formula.

Vaya con Dios,
Chuck, CABGx3
Click to expand...

...Ray
 
Try this:

=IF(H6,H6,IF(J6,J6,""))

If by some quirk, both cells contain numbers, then H6 takes precedence.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
I tryed it but got the dreaded #value! in the cell.

Thanks

Try this:

=IF(H6,H6,IF(J6,J6,""))

If by some quirk, both cells contain numbers, then H6 takes precedence.
Click to expand...

...Ray
 
Perhaps try also:

=IF(AND(ISNUMBER(H6),NOT(ISNUMBER(J6))),H6,IF(AND(NOT(ISNUMBER(H6)),ISNUMBER
(J6)),J6,""))
 
this should have worked unless your cells are actually have test in them...
hmm..
try this:
=IF(N9<>0,N9,IF(O9<>0,O9,""))
this should cover everything unless the cell value is zero

HTH
DF
 
Ray,

The #Value! error would suggest that you have text in the cell or that it is
formatted as text. Try re-formatting the cells and re-entering the data or
change the formula to:

IF(H6<>"",H6,IF(J6<>"",J6,""))


--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
If you got #VALUE then probably one or both of the cells have TEXT in
them.........is that the normal case?
If so then,
=IF(ISTEXT(H6),H6,IF(ISTEXT(J6),J6,""))

Vaya con Dios,
Chuck, CABGx3
 
On Fri, 29 Jul 2005 11:30:21 +0100, "Sandy Mann"

Thanks to all you have jumped in here.

All of the formulas appear to work fine. But i do have a confession to
make... i should have mentioned, if either cell has number in it, then
"devide" by cell "J6". I know I should have mentioned this in the
beginning...

Ray,

The #Value! error would suggest that you have text in the cell or that it is
formatted as text. Try re-formatting the cells and re-entering the data or
change the formula to:

IF(H6<>"",H6,IF(J6<>"",J6,""))
Click to expand...

...Ray
 
Do you have a typo somewhere?

You're saying that if J6 contains a number, then divide it by itself (J6)?

That's the same thing as returning a "1" if J6 is populated with any number.

Care to clarify?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

On Fri, 29 Jul 2005 11:30:21 +0100, "Sandy Mann"

Thanks to all you have jumped in here.

All of the formulas appear to work fine. But i do have a confession to
make... i should have mentioned, if either cell has number in it, then
"devide" by cell "J6". I know I should have mentioned this in the
beginning...

Ray,

The #Value! error would suggest that you have text in the cell or that it is
formatted as text. Try re-formatting the cells and re-entering the data or
change the formula to:

IF(H6<>"",H6,IF(J6<>"",J6,""))
Click to expand...

...Ray
 
Since one of your earlier posts mentioned that now "all formulas work", I'm
assuming that you corrected any formatting discrepancies that you might have
had before, so ... I repeat my original suggestion, with a revision to meet
your latest request:

=IF(H6,H6/J2,IF(J6,J6/J2,""))

Of course, you'll need J2 to be populated, or get a #DIV/0! error!

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Thanks again.... the below solution worked. Yahoo.....
Since one of your earlier posts mentioned that now "all formulas work", I'm
assuming that you corrected any formatting discrepancies that you might have
had before, so ... I repeat my original suggestion, with a revision to meet
your latest request:

=IF(H6,H6/J2,IF(J6,J6/J2,""))

Of course, you'll need J2 to be populated, or get a #DIV/0! error!
Click to expand...

...Ray
 
Well done RD!
Good job of hanging in there until the OP had a good solution that satisfied
his needs.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top