Query related to Excel

[Excel]

Hello Everyone, 

How to give conditions with the help of IF function :

1. one if all 3 columns are TRUE or 1 column is TRUE and the others N/A, or 2 True and 1 N/A then it should show  In Compliance.

2. If 1 column or more are FALSE it should show Defect

3. If all 3 columns are N/A then it should show N/A.

Please help.. 

Here is a attached file...

[#2 · Accepted solution]

@Excel You may try below formula.

=IFERROR(IF(AND(A1:C1),"Incomplete","Defect"),"N/A")