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