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 · Accepted solution]

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 : )

[Jack6627]

@atcodedog05 thanks for pointing this out. This worked effortlessly! 🙂

[atcodedog05]

Happy to help : ) @Jack6627 

Cheers and have a nice day!