Excel formulas with an added alias @ behind the equals sign as output

Help Studio
1

Hi all, I was trying to use the activity write cell workbook to add in a formula =MINIFS(Z:Z,E:E,E2) and the output gives =@MINIFS(Z:Z,E:E,E2) in the cell. Please help me. thanks.

2

Hi @jollie_ng

Can you try with Excel activities

A workflow displayed in an automation tool that processes the specified Excel file "Input.xlsx" to write the smallest value from column C where column B matches cell B2 into cell C13 of Sheet1. (Captioned by AI)
A workflow displayed in an automation tool that processes the specified Excel file "Input.xlsx" to write the smallest value from column C where column B matches cell B2 into cell C13 of Sheet1. (Captioned by AI)585×784 25.7 KB

Regards,

3

Hi @jollie_ng

Please check below link,

If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath

4

Use fill range option instead of write range option

Automation script configuring an Excel file to write a formula in a specified range. (Captioned by AI)
Automation script configuring an Excel file to write a formula in a specified range. (Captioned by AI)717×634 22.6 KB

5

@jollie_ng

Please use excel activities..with workbook activities it would convert as string

Cheers