Double IF

[Pippy79]

HI All,

Could do with a hand on the below,

If in D1, Cell B1 is "A" and C1 is "yes" show date in A1 and also If B1 is "B2 and C1 is "yes" show date in A1 +1 day

will always be either Yes or blank and i will only need a response when it is yes.

	A	B	C	D
1	30-Aug	A	Yes	IF Here
2		B	Yes
3

Thanks

 

[Fluff]

How about

=IF(AND(B1="A",C1="yes"),A1,"")

 

[Pippy79]

HI Fluff,

this works but there could be 2 options within cell B1 so if it is A and yes do this if it is B and Yes do that

 

[Fluff]

Do you mean if B1 is not blank & C1 is Yes, show A1?

 

[Pippy79]

Cell B1 could show either "a" or "b" as a result. if "a" then the answer is cell A1 but if B1 shows "b" then the answer is A1 +1 day

 

[Fluff]

Ok, how about

=IF(C1<>"yes","",IF(B1="A",A1,A1+1))

 

[Pippy79]

thanks Fluff that works, what does the "<>" do?

 

[Fluff]

It means not equal to.

Glad to help & thanks for the feedback.