Need help with this formulas

[Soudios (Sou)]

“=SI(F”+Count.ToString+“=”“”“;”“”“;F”+Count.ToString+“)”

[Robinnavinraj_S]

Hi @Soudios

can you share your expected output

[NervYerem]

Looks like you’re using ; instead of ,

Try:
“=SI(F”+Count.ToString+“=”“”“,”“”“,F”+Count.ToString+“)”

The error seems to be asking you to do this:

[Jeroen_van_Loon]

Better yet… mak a complete english variant of the formula.

Excel in other than english languages translate formulas as well. But only on a UI level. If you use interop/api access of excel, such as UiPath does, the core language of the formula is still english, using english settings. Even though in the gui it is your native language, and it is only a ‘layer’ on top. Gotta love Microsof logic.

So not only change the separator to comma, but also translate the ‘SI’ into ‘IF’.

→ “=IF(F”+Count.ToString+"="""","""",F"+Count.ToString+")"

[Soudios (Sou)]

@Jeroen_van_Loon

Thank you its working