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.