mardi 18 octobre 2016

IF AND Formula with IS NOT NULL in Excel

I am using Excel 2010 and currently trying to get a formula for my data using a Nested If And, but unable of the correct formula.

Here is some sample data to elaborate on my point:

(A1)   Received Date    (B1)  DueDate
(A2)  7/1/2016          (B2)  7/8/2016
(A3)  7/1/2016          (B3)  6/29/2016
(A4)  7/1/2016          (B4)  NULL

Basically, I want to create a formula that satisfies the following conditions. If Received Date < DueDate AND DueDate IS NOT NULL...then "YES", else "NO". So in this sample code above, only the first record should return "YES" and the other two should return "NO."

How do I do about a formula doing this?

I don't know how to do the second condition, the IS NOT NULL part. I put the cell numbers in parenthesis to simulate the table. (Hope that helps.)

Aucun commentaire:

Enregistrer un commentaire