Nested If question

EduPAz

Board Regular
Joined
Mar 18, 2017
Messages
69
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,438
Office Version
  1. 365
Platform
  1. Windows
For line 1:
Code:
=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","")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,662
Messages
5,573,479
Members
412,532
Latest member
crazzyapple
Top