hello, I am looking on the best approach to bring the Excel type of Macro to the DataPrep - it is multicondition macro. example:
=IF(AQ3="",50,IF(AQ3>1000,25,IF(AND(AQ3<1001,AQ3>100),20,IF(AND(AQ3<101,AQ3>50),15,IF(AND(AQ3<51,AQ3>25),10,5)))))*2
any tips