R
RayD
Hello everyone,
What is wrong with my formula??
=IF(H6,J6>1,"")
Thanks
What is wrong with my formula??
=IF(H6,J6>1,"")
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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
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
R
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
...Ray
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
R
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!
==============================================
=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!
==============================================
R
Ray Dobson
I tryed it but got the dreaded #value! in the cell.
Thanks
...Ray
Thanks
Try this:
=IF(H6,H6,IF(J6,J6,""))
If by some quirk, both cells contain numbers, then H6 takes precedence.
...Ray
S
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
[email protected]
Replace@mailinator with @tiscali.co.uk
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
[email protected]
Replace@mailinator with @tiscali.co.uk
C
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
them.........is that the normal case?
If so then,
=IF(ISTEXT(H6),H6,IF(ISTEXT(J6),J6,""))
Vaya con Dios,
Chuck, CABGx3
R
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
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
R
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
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
R
RayD
R
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!
==============================================
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!
==============================================
R
Ray Dobson
Thanks again.... the below solution worked. Yahoo.....
...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!
...Ray
C
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
Good job of hanging in there until the OP had a good solution that satisfied
his needs.
Vaya con Dios,
Chuck, CABGx3