Hi
I am new in UiPath and I have usecase where I need to write formula in excel cell
Please help me how to do that.
“=IF(A1=”“Yes”“,”“Done”“,”“Pending”“)”
If using variables:
“=SUM(A1:” + variableCell + “)”
For example:
“=SUM(A1:” + myVariable.ToString + “)”
Hope it’s help happy Automation 
Hi @Mahera_Khan
Welcome to UiPath
Like this you can customize your formulas..
If helpful, mark as solution. Happy automation with UiPath! 
Welcome to the community
Just how you write in excel you would do it the same way..but you need to enclose everything from start to end in doublt quotes (")
Apart from that if in formula , if there are any double quotes then you need to escape with extra fouble quote ("")
Cheers