ok.. this is going to work better..

=IF(AND(A1="yes", sheet2!a1="yes", sheet3!a1="yes"),"acceptable","not
acceptable")

"blake7" wrote:

Hi I have the following if statement, it work fine if the relevant cells on
the sheet contain "yes", it shows "acceptable" but it shows FALSE when one
cell contains "No" instead of showing "not acceptable"

Where have I gone wrong. Thanks (Newbie)

=IF(OR(A1="yes"),IF(OR(Sheet2!A1="yes"),IF(OR(Shee t3!A1="yes"),"acceptable","not acceptable")))