Write Cell - Formula Error

Help Activities
, ,
1

Hi Everyone,

I am trying to write a content with a formula to the cell I specified with Write cell, but I am getting the error you see in the image. Is there anyone who can help? Thanks in advance.

MicrosoftTeams-image (7)
MicrosoftTeams-image (7)1920×1080 205 KB

Regards

2

Did you test to follow the suggestion in the error message, i.e. replace all semicolons with commas instead.

image
image911×123 6.44 KB

3

Yes, i also tried it but getting same error. I cant understand the problem.

Thanks for the advice.

4

The formula looks good but just checking, if any other excel document is open

image
image715×54 13.1 KB

5

Thanks for the advice, I close it manually and also kill the excel before debug. Still same error. I am not sure is it a bug or something else.

6

Except for replacing semicolons with commas, you also need to change comma to period first, e.g. “0,99” to “0.99”. Also I believe the function names should be in English, e.g. YIL to YEAR.

You can use the tool below to convert your formula to English:

2 Likes
7

Thanks for the help. Like you said, Formula need to be english and number seperators need to be dot.

The tool is great too. Thanks again.

Regards

1 Like
8

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