If Then Statements

[makiboy]

I have been successful doing if then statements, however for some reason I'm stuck on this one.

I have a section of cells that contains 10 rows. Within the 10 rows, I am only concerned about 3 of the rows of information. These three rows are considered "Critical" to my project.

I have to cells, B3 and B4 and B6 that I am concerned with.

Of the 10 rows, if any of the 3 I am concerned with are of a certain criteria, then there is a "compliance" issue.

For example, if any of the three rows B3, B4 and B6 contain a "1", then we are "in compliance" (which is what the cell should show). If any of the three rows B3, B4 and B6 contain a "0" then we are "Out of compliance".

I tried doing a =IF(B3=1,"In Compliance",IF(B3=0, "Out of Compliance",IF(B4=0, "In Compliance".....etc......

but this didn't work. Any ideas on how to write this formula? Thanks!

 

[jberwald]

Welcome to the board.

Try this, I think it should work for you.

=IF(AND(B3=0,B4=0,B6=0),"In Compliance","Out of Compliance")

 

[makiboy]

Thanks Jberwald......

Your suggestion didn't work. Maybe I didn't make it clear enough. I need it to report an "Out of Compliance" if any of the 3 statements are "0". If two are "1" and one is "0"....it should report "Out of Compliance". If all three are 1's, it would report "In Compliance". Does that make sense? Putting your formula in, it only gives me an "Out of compliance" if all of them are at "0".

Thanks SO MUCH! For your help, I really appreciate it!

 

[jberwald]

Try this one

=IF(OR(B3=0,B4=0,B6=0),"Out of Compliance","In Compliance")

 

[makiboy]

Great Jberwald.....looks like that may work, thanks a bunch! I appreciate it!