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!!!
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!!!