I am trying to put one formula in excel shell, the formula is " =IF(G2>10,“10+ Days”,IF(G2>3,“4-10 Days”,IF(G2>1,“2-3 Days”,“0-1 Day”)))" but its not working in UI path studio… but manually working in excel sheet… Kindly provide a solution
please confirm me, are you trying to insert formula as a value to cell or reading formula from cell?
what happens when you do it with UiPath?
Are you using write range to write the formula into excel?
Getting one error while doing this formula in excel using write cell activity.
Original Formula: =INDEX(File1_TableCalc!C:C,MATCH(A2&H2,File1_TableCalc!A:A&File1_TableCalc!C:C,0))
Formula getting pasted:
=INDEX(File1_TableCalc!C:C,MATCH(A2&H2,@File1_TableCalc!A:A&@File1_TableCalc!C:C,0))
Can any one help why this @ is getting added?