if statement formula

[jrook20]

Hi all,

I am looking to create a formula for an if statement I am using in excel. The excel formula is:

=if(G2=“Dog”,if(H2=“B”,MAX(M2-L2,0),if(H2=“S”,MAX(L2-M2,0),ABS(L2-M2))),M2)

Column G is “Animal”

Column H is “Buy Sell”

Column M is “Month over Month Proce”

Column L is “Monthly Price”

Thanks

[binu_acs]

@jrook20 I think you need a combination of formula tool and summarize tool to calculate the formula in alteryx