IF Function conidtion of two colommes and Formule with % in condition

[Ayari]

Hello ,

i m converting a hug excel file to alteryx , and i need to translate this formule in excel : =SI(ET(BR4>=95%*BL4;BR4<=105%*BL4);BR4;BL4)

i used Formul tool and i wrote this , IF [Qte_Rec_Tot] >= 95% * [Qte_Cde_Tot_Init] THEN = [Qte_Rec_Tot] ELSEIF [Qte_Rec_Tot] <=105% * [Qte_Cde_Tot_Init] THEN ELSE = [Qte_Cde_Tot_Init] ENDIF

it dosent support the pourcentage in formule and i cant get how can i make a new colommes based on this conditoin that compares between two colommes , i wish you could understand my probleme 🙂

[atcodedog05]

Hi @Ayari 

0.95 should be equivalent to 95%. You can try decimal form of percentage in the formula.