multiple if criteria with 3 results option

[r_2]

hi
following are the requirement
if d = pending with UIDAI(DQC) & E= ""(blank) column G will reflect pending with customer.
if d= other option & E=blank column G will reflect pending wth team.
if E= non blank column G will reflect closed


my column F function is working , were if criteria is =if (E2="","pending with team", "closed").
need to add the criteria of column D with above that is =if (D2=Pending with UIDAI(DQC),E2=""),"Pending with customer","Pending with team").

pls help to merge this 3 criteria....

my g columns if is showing the value.

 

[Swapnil]

Hi,

Please try

=IF(AND(D2="Pending with UIDAI(DQC)",E2=""),"Pending with customer",IF(E2="","Pending with team","Closed"))

Attaching file for your ready reference.

 

[r_2]

thnx swapnil ...