If (And) Statement adjustment

[squeakums]

If I want to write in also, if f8='yes' and g8=yes how would I got about it?

=IF(AND(G8="yes", AD8="DEVELOPS MODEL"),"Yes",IF(AND(G8="yes", AD8="PROVIDES DATA FOR MODEL"), "Yes",IF(AND(G8="yes",AA8="direct"),"Yes",IF(AND(G8="yes",AB8="yes"),"Yes", IF(AND(G8="yes",AC8="yes"), "Yes", "No")))))

 

[RoryA]

Try this:

=IF(G8="yes", IF(OR(AD8="DEVELOPS MODEL",AD8="PROVIDES DATA FOR MODEL",AA8="direct",AB8="yes",F8="yes"),"Yes","No"),"No")