Help combining multiple "if" statements

[datadummy]

I need help combining the following 2 IF statements:=IF(D3="Y","Y",IF(D3="N","N","")) and =(IF(F3="pos","Y",IF(F3="neg","N",""))). I have tried multiple ways and it keeps erring out on me.

 

[S.H.A.D.O.]

Do you mean something like this?

=IF(AND(D3="Y",F3="pos"),"Y",IF(AND(D3="N",F3="neg"),"N","Don't Match Either Criteria"))

I hope this helps!

 

[datadummy]

Awesome, thanks!!!!

Do you mean something like this?

=IF(AND(D3="Y",F3="pos"),"Y",IF(AND(D3="N",F3="neg"),"N","Don't Match Either Criteria"))

I hope this helps!

 

[S.H.A.D.O.]

You're welcome, have a great weekend!

 

[mrhstn]

Just for fun, this would also work

=CHOOSE(1+((D3="Y")*(F3="pos"))+((D3="N")*(F3="neg")*2), "No Match", "Y", "N")

Have a good weekend

 

[S.H.A.D.O.]

=CHOOSE(1+((D3="Y")*(F3="pos"))+((D3="N")*(F3="neg")*2), "No Match", "Y", "N")

Nice .