=if(or(a1="Altstatten",b1="Altstatten"),"Yes","No" )

"Altstatten" wrote:

I understand the syntax for an IF formula. (IF(True, Then This, Otherwise
This)

Question is, can I make the first of the three variables an AND or an OR
statement? Have tried a few variations and can't get anything to work.

I'm after...IF(this OR this, then this, otherwiese, this)

Any help??

Thanks
Phillip