In excel file i want to create new calculated column "Y/N "and create new excel for "Y"

[AnkitDwivedi6]

to calculate new column and filter and publish "Y" data it in new excel.

Col 1	Col 2	Col 3	Col 4	Calculated column
1	5	55	47	if(abs(5)>abs(0.5*55),"Y","N")
2	6	52	85	if(abs(6)>abs(0.5*52),"Y","N")
3	3	54	69	if(abs(3)>abs(0.5*54),"Y","N")
4	6	52	96	if(abs(6)>abs(0.5*52),"Y","N")

[Emil_Kos]

Hi @AnkitDwivedi6,

Please find the workflow attached. The workflow will not produce output as a result of all the formulas is equal to false. 

[pedrodrfaria · Accepted solution]

Hi @AnkitDwivedi6 

Here is an example where based on the logic of if(abs(Column 2)>abs(0.5*Column 4),"Y","N"). We create these fields to be populated with the Y or N.

Pedro.