More IF Statement questions

[Wonder]

Thanks for all your help on my other IF question but I have another.


I want to say the following:

If G4=Y and I4=Y, enter the valule of 2. But if G4=Y and I4=N, enter
the value of 1. But if G4=N and I4=Y, enter the value of 1. But if
G4=N and I4=N, enter the value of 0.


I tried to figure it out, but I really don't know.

 

[Bob Phillips]

=IF(G4="Y",IF(I4="Y",2,1),IF(I4="Y",1,0))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

=IF(AND(G4="Y", I4="Y"),2,IF(AND(G4="N", I4="Y"),1,IF(AND(G4="Y",
I4="N"),1,0)))


Hope this helps.

 

[Wonder]

Both of those worked.....thank you so much.

=IF(AND(G4="Y", I4="Y"),2,IF(AND(G4="N", I4="Y"),1,IF(AND(G4="Y",
I4="N"),1,0)))


Hope this helps.