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?

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

Hi!

Try this:

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

Biff

"kvnexcel" wrote in message
...
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?

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" wrote in message
...
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?

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

You're welcome. Thanks for the feedback!

Biff

"kvnexcel" wrote in message
...
BIFF -- Worked like a charm! Thanks.

"Biff" wrote:

Hi!

Try this:

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

Biff

"kvnexcel" wrote in message
...
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?