How to apply formula in excel

[Mathkar_kunal]

hello,
i need to apply one formula in excel
=IF(C2=“”,A2&““&B2,A2&””&B2&“_”&C2)

for one of the column how can i appply?
please help me on same.

[Anil_G (Anil Gorthi)]

@Mathkar_kunal

Please try this in write cell formula activity

"=IF(C2="""",A2&""*""&B2,A2&""* ""&B2&""_""&C2)"

Cheers

[Mathkar_kunal]

ok i will try.

[Mathkar_kunal]

if i am writing as string giving error.
help me on same how to write.
this is the formula mwntioned in image

[postwick (Paul Ostwick)]

https://forum.uipath.com/search?q=excel%20formula

[Anil_G (Anil Gorthi)]

@Mathkar_kunal

If there are double quotes in string escape them
By having one mor wdpuble quote

Cheers

[Mathkar_kunal]

can you write here same with quote

[Anil_G (Anil Gorthi)]

@Mathkar_kunal

Try this

"=Concatenate(A2,""_"",B2,""-"",C2)"

Cheers