ExcelIron ContributorAug 25, 2022Query 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 Complianc...Show MoreBook4.xlsx13 KBHarun24HRAug 25, 2022Excel You may try below formula.=IFERROR(IF(AND(A1:C1),"Incomplete","Defect"),"N/A") Book4.xlsx9 KB
Harun24HRAug 25, 2022Excel You may try below formula.=IFERROR(IF(AND(A1:C1),"Incomplete","Defect"),"N/A") Book4.xlsx9 KB
Harun24HRAug 25, 2022Excel You may try below formula.=IFERROR(IF(AND(A1:C1),"Incomplete","Defect"),"N/A") Book4.xlsx9 KB
Harun24HRBronze ContributorAug 25, 2022Excel You may try below formula.=IFERROR(IF(AND(A1:C1),"Incomplete","Defect"),"N/A") Book4.xlsx9 KB
Related ContentQuery related ExcelQUery related Excel formulaQuery related to drop downQuery related to Dropdown list in ExcelQuery related to VBA code
Recent Discussionsnew people only from arraySolvedExcel TEXTBEFORE function went away and gives #NAME? errorHow to use F2 for Excel on iPad Pro M4 with latest Magic KeyboardFormula VSTACK/HSTACK with blank arrayRan out of Resources
