Apr 22 2021 05:05 AM
Hello,
I have a nested IF AND statement, but i think i may be wrong with the brackets.
Can i ask that someone casts their eye over please.
I am not sure if i need closing brackets in each condition.
Thank you for your time
=IF(AND([Payment Method]="PPT - Partial",[Copy Docs emailed for approval]<=[Despatch Target.],"On Time", IF(AND([Payment Method]="OAC",[Despatch Date of Original Docs]<=[Despatch Target.],"On Time", IF(AND([Payment Method]="DOC",[Despatch Date of Original Docs]<=[Despatch Target.],"On Time",IF(AND([Payment Method]="LOC",[Despatch Date of Original Docs]<=[Despatch Target.],"On Time","Late")))))
Apr 22 2021 07:24 AM
Apr 23 2021 03:51 AM
@DairyG1 You were missing some closing brackets. Here's the corrected formula:
=IF(AND([Payment Method] = "PPT - Partial", [Copy Docs emailed for approval] <= [Despatch Target.]), "On Time", IF(AND([Payment Method] = "OAC", [Despatch Date of Original Docs] <= [Despatch Target.]), "On Time", IF(AND([Payment Method] = "DOC", [Despatch Date of Original Docs] <= [Despatch Target.]), "On Time", IF(AND([Payment Method] = "LOC", [Despatch Date of Original Docs] <= [Despatch Target.]), "On Time", "Late"))))
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Apr 23 2021 04:52 AM