Excel formula in cell

Help Studio
, ,
1

i need to write a excel formula in write cell activity , but this is showing end function error .how to correct this ?

“=B2&TEXT(F2,“mm-dd-yy”)&TEXT(G2,“mm-dd-yy”)&ROUND(ABS(H2),2)&ROUND(ABS(L2),2)”

2

@poojaskyrathore

Try like this

"=B2&TEXT(F2,""mm-dd-yy"")&TEXT(G2,""mm-dd-yy"")&ROUND(ABS(H2),2)&ROUND(ABS(L2),2)"

Cheers

3

there shouldnt be any bracket before b2?

4

@poojaskyrathore

Are you trying to concatenate all of those strings?

May I know what you wnat to acheive witht his formula…

I gave you how to write the same formula in write cell…and yes i dont see any missing brackets but if you want to concat then use concat(B2,…,xxx,yyy) like this

Cheers

5

Hi @poojaskyrathore

Can you pass the below excel formula in your write cell and check it again,

> "=B2 & TEXT(F2,""mm-dd-yy"") & TEXT(G2,""mm-dd-yy"") & ROUND(ABS(H2),2) & ROUND(ABS(L2),2)"

I didn’t get any error while writing the formula to a cell as shown in below screenshot,
image

Hope this might help you :smiley: