I struggle since this morning on typing formulas on excel.
Thanks to that forum, I already know that I must write " , " to have a " ; ", but I have another problem, and impossible to find a topic on that, maybe the keywords are too common.
I have that formula that I need to type : =RECHERCHEV(H13;‘List of IO’‘s’!A:B;2;FAUX)
I have wrote it that way, in a “write cell” activity, inside an Excel application scope : “=RECHERCHEV(H13,‘List of IO’‘s’!A:B,2,FAUX)”
The problem is when I open excel after the robot run, I got an error in the cell and I can read that inside : =RECHERCHEV(H13;‘List of IO’‘s’!A:B;2;‘FAUX’)
The problem comes from the simple quotes around the FAUX
Why do they appear, and how could I get rid of them ?
Thank you all