IF Formula in Alteryx

[Sarath27]

Hi All,

Could you please help replicating this excel formula in Alteryx  (=IF(A2=1,B2,"") ? And also explain what this formula says? Thanks in Advance.

I also added example file for your reference.

[ShankerV]

Hi @Sarath27 

This can achieved with the help of Formula tool in Alteryx

Many thanks

Shanker V

[ShankerV]

Hi @Sarath27 

One way of doing this.

 

 

Many thanks

Shanker V 

[ShankerV · Accepted solution]

Hi @Sarath27 

The formula says  (=IF(A2=1,B2,"")

IF value in the cell A2 = 1

THEN Display the value from the cell B2

ELSE "" means empty cell

I have replicated the same above formula used in Excel to Alteryx format to reach the result.

Hope this helps!!! Feel free to ask if you have more questions!!!!

Many thanks

Shanker V

[Sarath27 · Accepted solution]

Hi @ShankerV Thanks much for the very prompt response. Much appreciated!