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")))

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")))

try this, (untested)
=IF(OR(A1="yes",Sheet2!A1="yes",Sheet3!A1="yes")," acceptable","not
acceptable")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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")))

if the OP wnats to show acceptable only if al lconditions are true, probably
looking for the AND one. Took me a while to get through all the OR's myself.
:-)

"Don Guillett" wrote:

try this, (untested)
=IF(OR(A1="yes",Sheet2!A1="yes",Sheet3!A1="yes")," acceptable","not
acceptable")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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")))

blake7;223731 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")))

Maybe try =IF(and(A1="yes",Sheet2!A1="yes",Shee
t3!A1="yes"),"acceptable","not acceptable")


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61920

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")))

=IF(AND(A1="yes",Sheet2!A1="yes",Sheet3!A1="yes"), "acceptable","not
acceptable")


On Feb 11, 1:24*am, 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")))