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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested IF 2
Nested IF statements using AND / OR 2
If function help 0
How do I add iserr or iserror to this 9
Returning a value if multiple conditions are met 2
Multiple IF statement 1
Nesting IF/OR Statement 14
Testing for conditions with IF statement and AND function 1

Back
Top