+ Reply to Thread
Results 1 to 4 of 4

How do I nest IF statements to only return value if both true?

  1. #1
    kvnexcel
    Guest

    How do I nest IF statements to only return value if both true?

    I have a cell, M30, in which I want to display contents copied from another
    cell (D18), provided that two different conditions are met: K24=Y and M29
    has some text content in it already. Otherwise, M30 is blank.
    The basic IF statement I've written for M30 is =IF(k24="y",D18,""), but
    that only takes care of the first condition. How do I make it test for the
    second condition, that M29 has some text in it?

  2. #2
    Biff
    Guest

    Re: How do I nest IF statements to only return value if both true?

    Hi!

    Try this:

    =IF(AND(K24="Y",M29<>""),D18,"")

    Biff

    "kvnexcel" <[email protected]> wrote in message
    news:[email protected]...
    >I have a cell, M30, in which I want to display contents copied from another
    > cell (D18), provided that two different conditions are met: K24=Y and
    > M29
    > has some text content in it already. Otherwise, M30 is blank.
    > The basic IF statement I've written for M30 is =IF(k24="y",D18,""), but
    > that only takes care of the first condition. How do I make it test for the
    > second condition, that M29 has some text in it?




  3. #3
    kvnexcel
    Guest

    Re: How do I nest IF statements to only return value if both true?

    BIFF -- Worked like a charm! Thanks.

    "Biff" wrote:

    > Hi!
    >
    > Try this:
    >
    > =IF(AND(K24="Y",M29<>""),D18,"")
    >
    > Biff
    >
    > "kvnexcel" <[email protected]> wrote in message
    > news:[email protected]...
    > >I have a cell, M30, in which I want to display contents copied from another
    > > cell (D18), provided that two different conditions are met: K24=Y and
    > > M29
    > > has some text content in it already. Otherwise, M30 is blank.
    > > The basic IF statement I've written for M30 is =IF(k24="y",D18,""), but
    > > that only takes care of the first condition. How do I make it test for the
    > > second condition, that M29 has some text in it?

    >
    >
    >


  4. #4
    Biff
    Guest

    Re: How do I nest IF statements to only return value if both true?

    You're welcome. Thanks for the feedback!

    Biff

    "kvnexcel" <[email protected]> wrote in message
    news:[email protected]...
    > BIFF -- Worked like a charm! Thanks.
    >
    > "Biff" wrote:
    >
    >> Hi!
    >>
    >> Try this:
    >>
    >> =IF(AND(K24="Y",M29<>""),D18,"")
    >>
    >> Biff
    >>
    >> "kvnexcel" <[email protected]> wrote in message
    >> news:[email protected]...
    >> >I have a cell, M30, in which I want to display contents copied from
    >> >another
    >> > cell (D18), provided that two different conditions are met: K24=Y and
    >> > M29
    >> > has some text content in it already. Otherwise, M30 is blank.
    >> > The basic IF statement I've written for M30 is =IF(k24="y",D18,""),
    >> > but
    >> > that only takes care of the first condition. How do I make it test for
    >> > the
    >> > second condition, that M29 has some text in it?

    >>
    >>
    >>




+ 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