Multiple IF Statements Using "ISDATE"

bcg5140

I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is:

=IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail"))

I'd like to add an additional criterion that pulls in the selected status from the sheet summary. I'm struggling to do this with a nested IF(AND) statement given the use of ISDATE. The formula I've been trying to draft is:

=IF(AND(ISDATE([Closed Date]1, [Status]# = "Development", [Delivery Date]1 > [Closed Date]1), "Complete, "Fail"))

I also tried writing this using only IF statements and was similarly unsuccessful:

=IF([Status]# = "Development"), IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail"))

I'm at a loss of where to fix this - I can get it working halfway then get an error for "Incorrect Argument Set." Would appreciate any tips!

Adam Murphy

Try this: =IF([Status]# = "Development", IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")))

I do not see why that wouldn't work, just had to move the ). Note that this will not do anything if the Status is not "Development", and then if Closed Date is not a date, again it will do nothing. If you are looking for it to "Fail" in those scenarios it is easy to add.

The alternative way:

=IF(AND(ISDATE([Closed Date]1), [Status]# = "Development", [Delivery Date]1 > [Closed Date]1), "Complete, "Fail") should work (I did not test any of it). Hope this helps.

Adam Murphy

Try this: =IF([Status]# = "Development", IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")))

I do not see why that wouldn't work, just had to move the ). Note that this will not do anything if the Status is not "Development", and then if Closed Date is not a date, again it will do nothing. If you are looking for it to "Fail" in those scenarios it is easy to add.

The alternative way:

=IF(AND(ISDATE([Closed Date]1), [Status]# = "Development", [Delivery Date]1 > [Closed Date]1), "Complete, "Fail") should work (I did not test any of it). Hope this helps.

bcg5140

Thank you so much! The first formula solved it.