More IF Statement questions
 

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.

More IF Statement questions
 

=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)

"Wonder" wrote in message
ups.com...
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.

More IF Statement questions
 

=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" wrote:

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.

More IF Statement questions
 

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


Scott wrote:
=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" wrote:

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.