Uipath- Excel Formula With Write Cell Activity

Help Activities
, ,
1

Hi guys,

I’m trying to set some formula in Uipath Excel , but when I try to example formula like this it gives to me some error at below ;

My formula is like that ;

String.Format(“=EĞER(”“EMETİNSE(”“A2"”);““EVET””;““HAYIR””)"

My Error:

image
image777×169 36.4 KB

Could you please help me for exprassion format.

Best regards,

Thanks

2

hi @burakavuncu

looks like you’r ussing futher " than you need
please refer from that

best regards!

3

Hey man,

Its show basic formula. My formula should be like this , how can I write it ?

=IF(ISTEXT(A2);YES;NO)

4

Try this syntax

String.Format("=EĞER("“EMETİNSE(""A2"”);"“EVET”";"“HAYIR”")")

Regards
Gokul

5

Y are using Yes / No in the formula

Do need bool value try this formula

=IF(ISTEXT(A2),TRUE,FALSE)

Regards
Gokul

6

It’s not working mate. Is there any solution different ?

Thanks.

7

Can you elaborate your query little bit. If possible share the sample Input file @burakavuncu

Regards
Gokul

8

I’m gonna share my screenshot;

image
image729×188 5.71 KB

I’m trying to give this formula to excel cell.

Thanks.

9

Hi,

Can you try the following?

"=EĞER(EMETİNSE(""A2""),""EVET"",""HAYIR"")"

Regards,

10

Hi Mate,

I try it works but it write like this as you can see here there is “” on A2.

image

How can I fix it ?

Thanks.

11

Hi,

The following will work. Can you try this?

"=EĞER(EMETİNSE(A2),""EVET"",""HAYIR"")"

Regards,

12

It works, perfect !

But this time my excel gives error #AD? , do you know how can i fix that ?

image

Best regards,

13

Hi,

I’m not sure, but can you try English style as the following, for now?

"=IF(ISTEXT(A2),""EVET"",""HAYIR"")"

Regards,

1 Like
14

Thank you , it worked.

15

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