Multiple IF Conditions

Hi Experts!

I am trying to formulate a column using the reference formula from an excel template, but due to some reasons, the output is not what is expected.

This is in the excel- =IF(M2=12345;IF(S2<>0;S2;R2);IF(M2=67890;IF(S2<>0;S2;R2);IF(IF(B2="Sometext";R2;S2)<>0;IF(B2="Sometext";R2;S2);D2)))

This is what I did using formula tool- IIF([M1]=12345, IF [S1]!=0 THEN [S1.] ELSE [R1] ENDIF, IIF([M1]=67890, IF [S1]!=0 THEN [S1] ELSE [R1] ENDIF, IIF(IF [Sub Category]='Sometext' THEN [R1] ELSE [S1]!=0 ENDIF,[S1], [D1])))

Would you be able to help? Thanks

Regards.

Reporting

Accepted answers

Kaviyarasan_P

Hi,

I believe you will answer for your query

if ([M2]= 12345) then (if [S2] != 0 then [S2] else [R2]
endif) else (if [M2]=67890 then (if ([S2]!= 0) then [S2] else [R2] endif) else (if (if([B2 ]='Sometext')then [R2] else [S2] endif) != 0 then (if([B2 ]='Sometext')then [R2] else [S2] endif) else[D2] endif)endif) endif