View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wonder
 
Posts: n/a
Default 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.