Nested If question

[EduPAz]

Hi, Can someone please help me with this?

I have a table like this:

Code --> Column A: ZSA, SAW, GEN, PT1,SSS, AAA,...
Phase---> Column B: Phase 1, Phase 0, Phase 1, Phase 2,Phase 0, Phase 1,....
Task-->Column C: 05-11, 05-4, 05-78,05-8,05-13,05-20......

I would like to create a new column with the name Client contract to every code that:

-Begins by S or Z
-Excludes Phase 0
-Excludes tasks: 05-1, 05-4 and 05-13

How can I do the nested IF?

Thanks!

Edu

 

[Joe4]

For line 1:

=IF(AND(OR(LEFT(A1,1)="S",LEFT(A1,1)="Z"),B1<>"Phase 0",C1<>"05-1",C1<>"05-4",C1<>"05-13"),"Client contract","")

 

[EduPAz]

Thanks!