multiple if statement

B

blake7

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(Sheet3!A1="yes"),"acceptable","not acceptable")))
 
L

Laura Cook

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

Don Guillett

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

Pecoflyer

blake7;223731 said:
Hi I have the following if statement, it work fine if the relevant cell
on
the sheet contain "yes", it shows "acceptable" but it shows FALSE whe
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(Sheet3!A1="yes"),"acceptable","no
acceptable")))
Click to expand...

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

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste
 
S

Sean Timmons

ok.. this is going to work better..

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

muddan madhu

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

Sean Timmons

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.
:)
 
Top