Please make sure that you are using correct quotes in the formula:
Sometimes when copying formulas from UiPath forum they need manual updating inside UiPath Studio.
This is how it looks like for me when I download you .xaml file:
and this is how it should look like:
Please check all of the quotes if they are correct.
i just downloaded your code and run it with the formula:
(“=IF(AND(J”+Counter.ToString+“=”+Chr(34) +“non”+Chr(34) +“;OR(D”+Counter.ToString+“=”+Chr(34) +“TVX”+Chr(34) +“;D”+Counter.ToString+“=”+Chr(34)+“PDD”+Chr(34)+“;D”+Counter.ToString+“=”+Chr(34) +“CICM”+“=”+Chr(34) +“;D”+Counter.ToString+“=”+Chr(34)+“EF”+Chr(34)+“));”+Chr(34)+“654200”+Chr(34)+“;”+Chr(34)+“654100”+Chr(34)+“)”).Replace(“;”,“,”)
but it did always give :
Did you try deleting .Replace(“;”,“,”) ? I added this since I use , as a separator in Excel, not ;
always the same thing, now i’m getting “Read range errorI dentifier expected”
any help 
?
sample.xlsx (15.9 KB)
test (1) (1).xaml (41.8 KB)
