IF CONDITION NOT GETTING

[J33PJEET]

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.

[#2 · Accepted solution]

@J33PJEET 

=IFS(SUM(C2:D2)<>0, 1, SUM(E2:F2)<>0, 2, SUM(G2:H2)<>0, 3, TRUE, "")

[#3]

THANKS BRO..