I have this formula and it doesn't work: =IF(A1="oui","1",if(A1="non","0",""))

I asked a couple of friends to test it, and oddly, it works fine with them!

What did I do wrong? And how do I fix it?

  • 2
    How does it not work? What does it output? – Vidar S. Ramdal Jan 20 '15 at 15:03
  • 1
    Try to use a semi-colon (;) – Jacob Jan Tuinstra Jan 20 '15 at 15:13
  • @pnuts Sorry chief! Post deleted from the other website! What do you mean by sheet's Locale? – user1885868 Jan 21 '15 at 19:10
  • @JacobJanTuinstra the semi-colon ; doesn't work. – user1885868 Jan 21 '15 at 19:11
  • @pnuts if I go to File, Spreadsheet settings it gives me Locale : France, Time zone : London and Recalculation : On change I just changed them to Locale : United States, Time zone : GMT and now it is working. Thanks! Does this mean that the commands don't work for French settings? – user1885868 Jan 21 '15 at 22:54

Browse other questions tagged or ask your own question.