Conditional IF/OR/AND

[MariaPaz]

 

Hi guys! I really need your help. I have a formula in Excel that I can't "copy" to Alteryx:

=if(or(and(ad18>0,ad22>0),and(ad18<0,ad22<0)),ad22,if(abs(ad18)<abs(ad22),af20,0))+ad27

please! I would really appreciate if you can help me!!!!! 

[Qiu]

@MariaPaz 

Can you provide a sample data?

[apathetichell]

Can you post some sample data? before I look at specific formulas I'd need to look at holistically how to turn this into data and see if these are relevant for the same records or different records. The actual formula isn't the difficult part - but you have a multi-row header which you'll need to filter through to create your data in a format you can use.  It could end up that each of your worksheets is best viewed as a single record - so some of your if statement would be moot because the transformation into data is more relevant.

[MariaPaz]

Hi! I upload the file. In the sheet "Rep 2b1-1b ME" I can't make the same formulas of the boxes from columns "AE to AH". Thank you in advance!!!

[MariaPaz]

Hi Aurora! Here is the sample data, I can't copy the formulas from columns "AE to AH".

Many thanks!!!!