Getting error while writing formula into Excel

Help Studio
1

Hi ,

I am getting an error like below while I am trying to write below formula into excel
=IF(A14=“”;“”;D14+E14) using write cell activity.

image
image542×532 13.6 KB

Error is like below:
image

This formula is correct. I have confirmed that by entering that into Excel:

image
image784×373 17.2 KB

Please help me folks

2

Did you try running the workflow while excel is closed?

3

Hi

Did we try with workbook activities instead of excel based activities

@NithyaSankar

4

No… Let me try

5

No… Will try

6

Hi @NithyaSankar

you can also do that as follows:
Stadard activities: UiPath | Write Formula in Excel | How to write formula in excel with UiPath | Excel Automation - YouTube
With VB.Net Code: UiPath | Write Formula in Excel | How to write formula in excel with VB.Net Code | Excel Automation - YouTube
With C# Code: UiPath | Write Formula in Excel | How to write formula in excel with C# Code | Excel Automation - YouTube

Best regards
Mahmoud