Write formula in excel

Help
1

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

2

I think there is a problem in your formula.

image

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

3

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

4

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.

5 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.