multiple if statement

  • Thread starter Thread starter blake7
  • Start date Start date
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")))
 
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")
 
try this, (untested)
=IF(OR(A1="yes",Sheet2!A1="yes",Sheet3!A1="yes"),"acceptable","not
acceptable")
 
ok.. this is going to work better..

=IF(AND(A1="yes", sheet2!a1="yes", sheet3!a1="yes"),"acceptable","not
acceptable")
 
=IF(AND(A1="yes",Sheet2!A1="yes",Sheet3!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.
:-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Code to format cells on several worksheets 2
If statement for a range of cells 3
Copying multiple cells out of multiple worksheets at same time. 1
If Statement Checking Formula NOT Value in a Cell 7
SUMIF function and cell /sheet reference 3
Drag down the cell links of multiple sheets 5
Removing Intermediary Connections 2

Back
Top