+ Reply to Thread
Results 1 to 9 of 9

ISNUMBER

  1. #1
    RJJ
    Guest

    ISNUMBER

    In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label B")

  2. #2
    Aladin Akyurek
    Guest

    Re: ISNUMBER

    =IF(COUNT(F2,J2),IF(J2>F2,"Text Label A","Text Label B"),"")

    RJJ wrote:
    > In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label B")


  3. #3
    Bob Phillips
    Guest

    Re: ISNUMBER

    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)

    "RJJ" <[email protected]> wrote in message
    news:[email protected]...
    > In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label B")




  4. #4
    RJJ
    Guest

    Re: ISNUMBER

    Yes they do. My error message states "You've entered too many arguements for
    this function". 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.
    "Bob Phillips" wrote:

    > 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)
    >
    > "RJJ" <[email protected]> wrote in message
    > news:[email protected]...
    > > In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label B")

    >
    >
    >


  5. #5
    RJJ
    Guest

    Re: ISNUMBER

    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 & F2.

    "Aladin Akyurek" wrote:

    > =IF(COUNT(F2,J2),IF(J2>F2,"Text Label A","Text Label B"),"")
    >
    > RJJ wrote:
    > > In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label B")

    >


  6. #6
    Bob Phillips
    Guest

    Re: ISNUMBER

    Try this

    =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2>F2,"Text Label A","Text Label
    B"),"")

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "RJJ" <[email protected]> wrote in message
    news:[email protected]...
    > Yes they do. My error message states "You've entered too many arguements

    for
    > this function". 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.
    > "Bob Phillips" wrote:
    >
    > > 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)
    > >
    > > "RJJ" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label

    B")
    > >
    > >
    > >




  7. #7
    RJJ
    Guest

    Re: ISNUMBER

    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 "zero" value. Zero values are hidden in tools/options.

    "Bob Phillips" wrote:

    > Try this
    >
    > =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2>F2,"Text Label A","Text Label
    > B"),"")
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > (remove nothere from email address if mailing direct)
    >
    > "RJJ" <[email protected]> wrote in message
    > news:[email protected]...
    > > Yes they do. My error message states "You've entered too many arguements

    > for
    > > this function". 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.
    > > "Bob Phillips" wrote:
    > >
    > > > 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)
    > > >
    > > > "RJJ" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label

    > B")
    > > >
    > > >
    > > >

    >
    >
    >


  8. #8
    RJJ
    Guest

    Re: ISNUMBER

    Got it. This is was worked.

    =IF(AND(F2>0, J2>0),IF(J2>F2,"Text Label 1","Text Label 2"),"")

    Thanks so much for all your help.

    "RJJ" wrote:

    > 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 "zero" value. Zero values are hidden in tools/options.
    >
    > "Bob Phillips" wrote:
    >
    > > Try this
    > >
    > > =IF(AND(ISNUMBER(F2), ISNUMBER(J2)),IF(J2>F2,"Text Label A","Text Label
    > > B"),"")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > (remove nothere from email address if mailing direct)
    > >
    > > "RJJ" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > Yes they do. My error message states "You've entered too many arguements

    > > for
    > > > this function". 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.
    > > > "Bob Phillips" wrote:
    > > >
    > > > > 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)
    > > > >
    > > > > "RJJ" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label

    > > B")
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >


  9. #9
    Aladin Akyurek
    Guest

    Re: ISNUMBER

    Sorry, I meant to say:

    =IF(COUNT(F2,J2)=2,IF(J2>F2,"Text Label A","Text Label B"),"")

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

    RJJ wrote:
    > 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 & F2.
    >
    > "Aladin Akyurek" wrote:
    >
    >
    >>=IF(COUNT(F2,J2),IF(J2>F2,"Text Label A","Text Label B"),"")
    >>
    >>RJJ wrote:
    >>
    >>>In cell K2, I wish to have the appropriate "Text LabeL" 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)),J2>F2,"Text Label A","Text Label B")

    >>


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1