I need to press "ENTER" in formula field to see it executed

[pp-91]

Hello and first of all: THANKS to your great work!

I run into a problem and would ask, if there is any solution or somebody has a similiar problem.

I am creating a cell with a formula: =SVERWEIS(C3;'Dropdowns'!$A$2:$B$8;2;FALSCH)

I figured out, that I need to write comma instead of semicolon, OK. I also learned, that I am not allowed to use the german FALSCH but need to use FALSE, because otherwise the result looked like =SVERWEIS(C3;'Dropdowns'!$A$2:$B$8;2;'FALSCH') and because of the 'FALSCH' it didn't work.

So, now I have the correct formula in the cell, but it shows "#NAME" everytime and I need to click into the cell and press ENTER. After I did this, everything is shown as it should!

Do you have an idea how to solve this problem?

Thanks in advance ans best regards.

[sayid]

您好，我已经收到您的信件，将尽快回复您。

[sayid]

您好，我已经收到您的信件，将尽快回复您。