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
Solved! Go to Solution.
Please help
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!
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, 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
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))))
Thank you so much @grazitti_sapna