IF formula help

[MaPurohit]

Hi all,

Hope you are doing well.

Can anyone help me with the formulas below in Alteryx design, please?

As I am new to Alteryx I tried my level best to find a possible way. 

=IF(B8>15%,((K8+L8+M8+N8)/B8*15%)-SUM(K8:N8),0) ,

=IF(AG5>0,IF(AI5<15,15-AI5,0),0)

=IF(AG5-AV5>0,IF(AI5<15,AG5-AV5,0),0)

I am not able to find any possible way to solve it.

Thanks in advance

[martinding]

Hi @MaPurohit,

In Alteryx, the If statements uses the following syntax:

IF conditon

THEN action

ELSEIF condition

THEN action

ELSE action

ENDIF

For example:

IF [Column1] > 20

THEN 'High'

ELSEIF [Column1] > 10

THEN ‘Mid'

ELSE 'Low'

ENDIF