Error in write cell (entering a formula)

Help Activities
, ,
1

Hi, I’m getting an error when trying to write a formula into a cell. The error I’m getting is:

image
image864×375 18.5 KB

The whole sequence works when I use a simple formula or random value. But for some reason it fails on this nested formula. I’ve also tried putting the formula into a variable first, but that gives me the same error. And I’ve checked for running instances of Excel, but that’s not the case either.

This is the part of the sequence where I’m using the activity:

image
image697×627 19.7 KB

What am I doing wrong here?

For now I’ve changed it to a simple formula which is working only partly. In that case the formula is entered fine, but not recognized by Excel as being a formula?

Vergelijken facturen en changes.zip (230.4 KB)

2

SOLVED: I had to use the English formula format. For me that’s =IFERROR(LEFT(B2,(SEARCH(“-”,B2))-1),“Geen C-nummer”).