03-20-2019 06:45 AM
Hi, I was trying to use the IF function and it wasn't working so i tried to make it as simple as possible to see what the problem was. Still, it gave me an error even though I just copied and pasted the formula from windows support page so I don't really know what to do.
03-20-2019 07:23 AM
03-20-2019 08:15 AM
SolutionPerhaps your list separator is not comma (e.g. semicolon). You may check Win+R type control international and here is under Additional settings
03-20-2019 08:24 AM
@Twifoo I believe this is the issue as well. Those quote marks look like smart quotes (curved quote marks) rather than proper actual quotation marks, which will break formulas in Excel (or nearly any programming language).
03-20-2019 09:16 AM
@Sergei Baklan wrote:Perhaps your list separator is not comma (e.g. semicolon). You may check Win+R type control international and here is under Additional settings
thanks a lot it really worked @Sergei Baklan
03-20-2019 09:17 AM
i already did it but as @Sergei Baklan said it was about typing semicolons instead of commas, but thanks anyway@Twifoo
03-20-2019 11:30 AM
@thomasea , glad to help