Not quite sure I follow what you are trying to do, but try the following and
let me know if it works:

=IF(OR(A1="Yes",Sheet2!A1="Yes",Sheet3!A1="Yes")," acceptable","not
acceptable")


"blake7" wrote in message
...
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")))