Query related to 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...