For the first time i was trying to use the IF statement on excel, and it seemed really simple to use, but for some reason even the most basic statement never works.

Example : =IF(A3=1;"Yes";"No") give no result as shown as #NOM?

I checked my regional settigns and my separator is ";", no doubt of it. Anyone have an idea ?

The error

CodePudding user response：

Are you using french Excel? Then you have to use SI instead of IF.

This page helps to translate the formulas: https://fr.excel-translator.de/