J33PJEETCopper ContributorSep 28, 2023SolvedIF CONDITION NOT GETTING IF SUM OF (C2 D2) <>0 THAN 1, OR BLANK IF SUM OF (E2 F2) <>0 THAN 2, OR BLANK IF SUM OF (G2 H2) <>0 THAN 3, OR BLANK IN J2 CELL. Show MoreHansVogelaarSep 28, 2023J33PJEET =IFS(SUM(C2:D2)<>0, 1, SUM(E2:F2)<>0, 2, SUM(G2:H2)<>0, 3, TRUE, "")
HansVogelaarSep 28, 2023J33PJEET =IFS(SUM(C2:D2)<>0, 1, SUM(E2:F2)<>0, 2, SUM(G2:H2)<>0, 3, TRUE, "")
HansVogelaarSep 28, 2023J33PJEET =IFS(SUM(C2:D2)<>0, 1, SUM(E2:F2)<>0, 2, SUM(G2:H2)<>0, 3, TRUE, "")
HansVogelaarMVPSep 28, 2023J33PJEET =IFS(SUM(C2:D2)<>0, 1, SUM(E2:F2)<>0, 2, SUM(G2:H2)<>0, 3, TRUE, "")
