Excel Formula to UiPath Write Cell

Help Studio
,
1

Apologies if this is a repeated question. In an excel file, I have successfully indicated the following formula: =IF(LEFT(B2,15)=Sheet2!B2,UNICHAR(10004),UNICHAR(10007))

In the UiPath write cell, I tried
String.Format(“=IF(LEFT({0},15)={1},UNICHAR(10004),UNICHAR(10007))”, CurrentRow.ByField(“Class ID”).ToLower, CRandNotes.Sheet(“Closure”).Cell(“A1”).ToLower)

And yet I received an error for it. Anyone knows why?

2

Hi @ShengChao_Soh

The Excel formula have the second = sign ? {0},15) = {1},

3

@GreenTea Hi, sorry. Don’t understand what you meant

4

Hi @ShengChao_Soh

Excel formula accepts equal sign at beginning of string, you have another equal sign
image