Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
J33PJEETCopper ContributorSep 28, 2023SolvedIF CONDITION NOT GETTINGIF SUM OF (C2 D2) <>0 THAN 1, OR BLANKIF SUM OF (E2 F2) <>0 THAN 2, OR BLANKIF SUM OF (G2 H2) <>0 THAN 3, OR BLANKIN J2 CELL. 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, "")
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, "")J33PJEETCopper Contributor to HansVogelaarSep 28, 2023THANKS BRO..
HansVogelaarMVPSep 28, 2023J33PJEET =IFS(SUM(C2:D2)<>0, 1, SUM(E2:F2)<>0, 2, SUM(G2:H2)<>0, 3, TRUE, "")