Sharepoint Calculated Column IF Statements

Question

Here's my formula:

=IF(Status="Completed",IF([JCN Type]="EDLM","UDLM",[Date Completed]+10),IF([JCN Type]="EA","TA",[Date Completed]+15))

I also want to have to be 10 or 15 work days but not really sure how to tie that in. Also, my third IF statement doesnt add any date in the field it add UDLM.

Answer 1

Hi @John kelly ,

Please try to use this:

=IF(Status="Completed",IF(OR([JCN Type]="EDLM",[JCN Type]="UDLM"),[Date Completed]+10,IF(OR([JCN Type]="EA",[JCN Type]="TA"),[Date Completed]+15)),"")  

Output:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You may use OR Function inside your if to make sure you joins multiple statements toghether.

https://support.microsoft.com/en-us/office/or-function-9a2a1cca-696f-4d19-a959-3943babd076f

Similar to OR, there is And function too. Please refer

https://support.microsoft.com/en-us/office/and-function-78956048-53c7-484a-ab0b-6e70d7f03400

Hope this helps