IF cell has data in it

[RayD]

Hello everyone,

What is wrong with my formula??

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


Thanks

 

[CLR]

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

 

[Ray Dobson]

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

...Ray

 

[RagDyer]

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

 

[Ray Dobson]

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.

...Ray

 

[Max]

Perhaps try also:

=IF(AND(ISNUMBER(H6),NOT(ISNUMBER(J6))),H6,IF(AND(NOT(ISNUMBER(H6)),ISNUMBER
(J6)),J6,""))

 

[iky]

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

 

[Sandy Mann]

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

 

[CLR]

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

 

[Ray Dobson]

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,""))

...Ray

 

[RagDyeR]

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,""))

...Ray

 

[RayD]

On Fri, 29 Jul 2005 08:01:05 -0700, "RagDyeR" <[email protected]>
wrote:

I am sorry it is cell "J2"

 

[RagDyer]

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

 

[Ray Dobson]

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!

...Ray

 

[CLR]

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