software

In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on J2 being
greater than or less than F2 but only if a value has been entered into J2 and
F2. I would not want any value in K2 if no values are entered into J2 and F2.
This is what I am attempting but not working. Any suggestions?

=IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;)

=IF(COUNT(F2,J2),IF(J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;),quot;quot;)

RJJ wrote:
gt; In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on J2 being
gt; greater than or less than F2 but only if a value has been entered into J2 and
gt; F2. I would not want any value in K2 if no values are entered into J2 and F2.
gt; This is what I am attempting but not working. Any suggestions?
gt;
gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;)

In what way is your formula not working? Does F2 and J2 contain formulae?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;RJJquot; gt; wrote in message
news
gt; In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on J2
being
gt; greater than or less than F2 but only if a value has been entered into J2
and
gt; F2. I would not want any value in K2 if no values are entered into J2 and
F2.
gt; This is what I am attempting but not working. Any suggestions?
gt;
gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;)
Yes they do. My error message states quot;You've entered too many arguements for
this functionquot;. But remember, I don't want any text in cell K2 if no numbers
are entered in F2 and J2. I intend to copy down this formula.
quot;Bob Phillipsquot; wrote:

gt; In what way is your formula not working? Does F2 and J2 contain formulae?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;RJJquot; gt; wrote in message
gt; news
gt; gt; In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on J2
gt; being
gt; gt; greater than or less than F2 but only if a value has been entered into J2
gt; and
gt; gt; F2. I would not want any value in K2 if no values are entered into J2 and
gt; F2.
gt; gt; This is what I am attempting but not working. Any suggestions?
gt; gt;
gt; gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;)
gt;
gt;
gt;

I've tried your suggestion but, the text label changes accordingly with
regards to greater than or less than however a text label is present in K2
even if no numbers are entered in J2 amp; F2.

quot;Aladin Akyurekquot; wrote:

gt; =IF(COUNT(F2,J2),IF(J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;),quot;quot;)
gt;
gt; RJJ wrote:
gt; gt; In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on J2 being
gt; gt; greater than or less than F2 but only if a value has been entered into J2 and
gt; gt; F2. I would not want any value in K2 if no values are entered into J2 and F2.
gt; gt; This is what I am attempting but not working. Any suggestions?
gt; gt;
gt; gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;)
gt;

Try this

=IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2gt;F2,quot;Text Label Aquot;,quot;Text Label
Bquot;),quot;quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;RJJquot; gt; wrote in message
...
gt; Yes they do. My error message states quot;You've entered too many arguements
for
gt; this functionquot;. But remember, I don't want any text in cell K2 if no
numbers
gt; are entered in F2 and J2. I intend to copy down this formula.
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; In what way is your formula not working? Does F2 and J2 contain
formulae?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;RJJquot; gt; wrote in message
gt; gt; news
gt; gt; gt; In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on
J2
gt; gt; being
gt; gt; gt; greater than or less than F2 but only if a value has been entered into
J2
gt; gt; and
gt; gt; gt; F2. I would not want any value in K2 if no values are entered into J2
and
gt; gt; F2.
gt; gt; gt; This is what I am attempting but not working. Any suggestions?
gt; gt; gt;
gt; gt; gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label
Bquot;)
gt; gt;
gt; gt;
gt; gt;
Close. The text label changes accordingly but am still having text show up in
K2 even though there are no numbers entered in F2 and J2. Could it be because
J2 and F2 are results of another arguement? In other words, F2=D2*E2 and
J2=D2*I2. So when I say nothing is in F2 or J2, what is really happening is
that there is nothing entered into D2, E2, or I2. However, a formula resides
in F2 and J2 with a quot;zeroquot; value. Zero values are hidden in tools/options.

quot;Bob Phillipsquot; wrote:

gt; Try this
gt;
gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2gt;F2,quot;Text Label Aquot;,quot;Text Label
gt; Bquot;),quot;quot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;RJJquot; gt; wrote in message
gt; ...
gt; gt; Yes they do. My error message states quot;You've entered too many arguements
gt; for
gt; gt; this functionquot;. But remember, I don't want any text in cell K2 if no
gt; numbers
gt; gt; are entered in F2 and J2. I intend to copy down this formula.
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; In what way is your formula not working? Does F2 and J2 contain
gt; formulae?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;RJJquot; gt; wrote in message
gt; gt; gt; news
gt; gt; gt; gt; In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on
gt; J2
gt; gt; gt; being
gt; gt; gt; gt; greater than or less than F2 but only if a value has been entered into
gt; J2
gt; gt; gt; and
gt; gt; gt; gt; F2. I would not want any value in K2 if no values are entered into J2
gt; and
gt; gt; gt; F2.
gt; gt; gt; gt; This is what I am attempting but not working. Any suggestions?
gt; gt; gt; gt;
gt; gt; gt; gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label
gt; Bquot;)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Got it. This is was worked.

=IF(AND(F2gt;0, J2gt;0),IF(J2gt;F2,quot;Text Label 1quot;,quot;Text Label 2quot;),quot;quot;)

Thanks so much for all your help.

quot;RJJquot; wrote:

gt; Close. The text label changes accordingly but am still having text show up in
gt; K2 even though there are no numbers entered in F2 and J2. Could it be because
gt; J2 and F2 are results of another arguement? In other words, F2=D2*E2 and
gt; J2=D2*I2. So when I say nothing is in F2 or J2, what is really happening is
gt; that there is nothing entered into D2, E2, or I2. However, a formula resides
gt; in F2 and J2 with a quot;zeroquot; value. Zero values are hidden in tools/options.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Try this
gt; gt;
gt; gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2gt;F2,quot;Text Label Aquot;,quot;Text Label
gt; gt; Bquot;),quot;quot;)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;RJJquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Yes they do. My error message states quot;You've entered too many arguements
gt; gt; for
gt; gt; gt; this functionquot;. But remember, I don't want any text in cell K2 if no
gt; gt; numbers
gt; gt; gt; are entered in F2 and J2. I intend to copy down this formula.
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; In what way is your formula not working? Does F2 and J2 contain
gt; gt; formulae?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;RJJquot; gt; wrote in message
gt; gt; gt; gt; news
gt; gt; gt; gt; gt; In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on
gt; gt; J2
gt; gt; gt; gt; being
gt; gt; gt; gt; gt; greater than or less than F2 but only if a value has been entered into
gt; gt; J2
gt; gt; gt; gt; and
gt; gt; gt; gt; gt; F2. I would not want any value in K2 if no values are entered into J2
gt; gt; and
gt; gt; gt; gt; F2.
gt; gt; gt; gt; gt; This is what I am attempting but not working. Any suggestions?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label
gt; gt; Bquot;)
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

Sorry, I meant to say:

=IF(COUNT(F2,J2)=2,IF(J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;),quot;quot;)

But this will consider also real 0's in F2 and J2 as a hit.

RJJ wrote:
gt; I've tried your suggestion but, the text label changes accordingly with
gt; regards to greater than or less than however a text label is present in K2
gt; even if no numbers are entered in J2 amp; F2.
gt;
gt; quot;Aladin Akyurekquot; wrote:
gt;
gt;
gt;gt;=IF(COUNT(F2,J2),IF(J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;),quot;quot;)
gt;gt;
gt;gt;RJJ wrote:
gt;gt;
gt;gt;gt;In cell K2, I wish to have the appropriate quot;Text LabeLquot; depending on J2 being
gt;gt;gt;greater than or less than F2 but only if a value has been entered into J2 and
gt;gt;gt;F2. I would not want any value in K2 if no values are entered into J2 and F2.
gt;gt;gt;This is what I am attempting but not working. Any suggestions?
gt;gt;gt;
gt;gt;gt;=IF(AND(ISNUMBER(F2), ISNUMBER(J2)),J2gt;F2,quot;Text Label Aquot;,quot;Text Label Bquot;)
gt;gt;