Please reference the IF syntax below:
=IF(a1="yes,"A1=YES","NOPE, IT DOESN"T WORK!")
The format for the above Statement, is as follows:
You can nest IF statements, as in:
=IF(A1="yes",IF(B1="yes","THEY ARE BOTH YES!","ONLY A1 is yes"),"neither one is yes")
I hope this has helped, and you have learned a little. Post back some code if you get stuck!
It's kind of fun to do the impossible! -Walter Elias Disney