Nested ifs in Multi-Row formula

Jack6627

I have a pretty convoluted nested if excel formula that I would like to embed into my Multi-Row formula tool. Can somebody please tell me how to write this to the tool?

=IF((IF(IF([A]="No",0,[B]-[C])<0,0,IF([A]="No",0,[B]-[C]))-[D])<0,0, (IF(IF([A]="No",0,[B]-[C])<0,0,IF([A]="No",0,[B]-[C]))-[D]))

atcodedog05

Hi @Jack6627 

One thing you can try is change Excel IF to IIF which is supported on Alteryx.

IF((IF(IF([A]="No",0,[B]-[C])<0,0,IF([A]="No",0,[B]-[C]))-[D])<0,0, (IF(IF([A]="No",0,[B]-[C])<0,0,IF([A]="No",0,[B]-[C]))-[D]))

to

IIF((IIF(IIF([A]="No",0,[B]-[C])<0,0,IIF([A]="No",0,[B]-[C]))-[D])<0,0, (IIF(IIF([A]="No",0,[B]-[C])<0,0,IIF([A]="No",0,[B]-[C]))-[D]))

Hope this helps : )