HI all, I have a problem with write cell activity. I want to put formula in one cell : “=IF(AND(A2 =H2; C2=J2);”“”“OK”“”“;”“”“NOT”“”“)” in excel, but UiPath send me error “The range does not exists” [Capture] Can someone help me, please! Thanks Matej

I did it. I create separate excel file where I store excel formula. I add activity Read Cell formula and paste it to main excel. Also, when you Read Cell Formula, you will get formula without “=” sign, so you need to add = sign before you paste it to excel.

I think there is a problem in your formula. [image] Using write cell you can set the value to a valid formula.

Hi, Probably you copied my formula, but this is formula for UiPath, I modified it because of usage of quotation marks. But exact formula is: =IF(AND(A2 =H2;C2=J2);“OK”;“NOT”) Thanks Matej

Write formula in excel

Help

mgosal (Mandip Gosal) December 18, 2018, 2:12pm 2

I think there is a problem in your formula.

Using write cell you can set the value to a valid formula.

Read Range /Write range convert string with " ' " character

Topic		Replies	Views
Write line: Excel formula for empty cells Help	7	2649	June 11, 2021
How to input excel formula into excel cell from write cell activity Activities excel , activities , studio , question , activities_panel	4	560	July 6, 2023
Writing Excel Formula from UiPath to Excel not working Help excel , activities , question	8	3234	December 19, 2021
Getting error while writing formula into Excel Studio uiautomation	5	1275	October 1, 2021
How to write formula to particular cell in excel Studio studio , question , tools	3	1179	July 27, 2021

Write formula in excel

Related topics