IF (And statement with date columns?

Deonizia Egan

I have tried several ways including Not(isblank and now using the current as blank fields and ISBLANK, and 0s, now just with quotes... it won't read both coluumns. it is say complete, even if only one column is not blank. i have another column with a similar formula that works GREAT, but it doesn't involve date columns.

=IF(AND([BG Complete]@row = "", [PPHDS Completed]@row = ""), "Pending", "Complete")

Dale Murphy

@Deonizia Egan You are using an AND statement, which means ALL conditions must evaluate as true to return the first outcome. The way I read your formula, if BOTH columns are blank, then the item is pending. Otherwise it is complete; meaning if EITHER of those columns is NOT blank, the result is Complete.

Is that your intent? Maybe you need an OR instead?

dm

Deonizia Egan

@Dale Murphy Yes that is my intent but that is not the outcome I am getting.

Deonizia Egan

@Dale Murphy it was my understanding that BOTH criteria had to be met in order to return the complete. I have an identical formula that only returns complete when both are met.

=IF(AND([Pending Addendums]@row = "No", Signed@row = 1), "Complete", "Pending")

here it is showing with both blank, and one or the other blank and it gives me pending in the right places and complete in the right place.

Dale Murphy

@Deonizia Egan You understand correctly. In your first formula, "pending" and "complete" were in reverse order, hence a different result. Unless I missed something?

dm