replicate excel formulas in alteryx

[Inactive User]

Sheet 1: =IF(F10=F9,0,MIN(0.05+0.95*EXP((H10-I10)/(2*0.95*G10)),1))

Sheet 2: =IF(F15=F14,0,MAX(G15-H15,0,(I15+J15-K15)))

Sheet 3: =IF(F20=F19,0,IF(G20="N",Sheet1!F12,IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0))))

Hi, team please help me to replicate these excel formulas in alteryx. Thanks in advance

[Inactive User]

Please help 

[grazitti_sapna]

Hello @Inactive User , I am able to replicate the first 2 formulas but the 3rd formula cannot be directly implemented as it involves lookup also in the lookup it is mentioned that you need Row F12 from sheet one but there is no value so can we assume that it is null by default or 0?

Can you please elaborate on the 3rd formula which you are trying to implement in sheet 3?

Thanks!

[Inactive User]

My bad, I will be right back

The formula is =IF(F20=F19,0,IF(G20="N",MAX(F12,IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0)))))

[Inactive User]

@grazitti_sapna 

[grazitti_sapna]

@Inactive User, in this formula 

=IF(F20=F19,0,IF(G20="N",MAX(F12,IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0)))))

What would be the value of F12 as for now in the sheet F12 is empty

[Inactive User]

I am extremely sorry for that. It is taking automatically. 

Here is the updated formula: =IF(F20=F19,0,IF(G20="N",MAX(H20-I20),IF(J20<0,MAX(K20-L20+M20,0),MAX(N20-O20,0))))

[grazitti_sapna · Accepted solution]

Hi @Inactive User, give this a try and let us know if it works for you?

I hope it works!

Thanks!

[fsalmon · Accepted solution]

Hi Thatiparti,

I believe what you're looking for is the multi-row formula tool. This lets you refer to previous rows in your calculations.

[Inactive User]

Thank you so much @grazitti_sapna