Help with IF Statement

[odonovanc]

I have the following formula and I want to add to it:

=IFERROR(IF(AND(P3="N",vlookup(C3,data!$A$3:$J$16,8,false)>0),(D3-vlookup(C3,data!$A$3:$M$16,8,false)),""),"")

I want all that functionality to stay the same if P3 is a N, but I want to add that if P3 = "Y" then it will return one day later the date in Q3 (So if Q3 was 3/4/2021, it will return 3/5/2021) instead.

Can someone help?

 

[jtakw]

Hi,

Just add to your IF statement:

=IFERROR(IF(AND(P3="N",VLOOKUP(C3,data!$A$3:$J$16,8,FALSE)>0),D3-VLOOKUP(C3,data!$A$3:$M$16,8,FALSE),IF(P3="Y",Q3+1,"")),"")