Error in write cell (entering a formula)

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

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:

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 (230.4 KB)

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