• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help if 2 cells are blank nested if statement

CarolM

New Member
Good morning. I love this site and it is my first goto place when I have questions! Thank you all!

I am trying to create an if statement but would like N/A if both dates are blank. I have 2 list of dates, planned and actual, if they are blank, I want it to say N/A. If there is even one date, I want it to be On Target or Missed Target. Here is my code that does not work....

I am not sure isblank/and will work:

=IF(ISBLANK(D9),AND(ISBLANK(E9), "N/A",IF(E9>D9,"Missed Target","On Target")))

Thank you smart excel people as always!!!
 
Good morning. I love this site and it is my first goto place when I have questions! Thank you all!

I am trying to create an if statement but would like N/A if both dates are blank. I have 2 list of dates, planned and actual, if they are blank, I want it to say N/A. If there is even one date, I want it to be On Target or Missed Target. Here is my code that does not work....

I am not sure isblank/and will work:

=IF(ISBLANK(D9),AND(ISBLANK(E9), "N/A",IF(E9>D9,"Missed Target","On Target")))

Thank you smart excel people as always!!!
Hi,,


Try this

=IF(COUNT(D9:E9)=0,"N/A",IF(E9>D9,"Missed Target","On target"))

or the correct syntax for yours.

=IF(AND(ISBLANK(D9),(ISBLANK(E9))), "N/A",IF(E9>D9,"Missed Target","On Target"))
 
Back
Top