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 ?
>Solution :
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/