Multi-Row Formula translation from Excel

How would I convert this Excel formula into Alteryx?

Preparation

Accepted answers

Hi @carterfleming

Please find the expected output.

Many thanks

Shanker V

Multi-Row Formula translation from Excel.yxmd

All comments

Hi @carterfleming

Please use,

IF ([Row-1:F1]="Yes" AND [Row-1:F2]="NO")

THEN [F3]+[F4]

ELSE 0

ENDIF

Hi @carterfleming

Please find the expected output.

Many thanks

Shanker V

Multi-Row Formula translation from Excel.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703