IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS

[thomasea]

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.

[#2]

Try to type the formula rather than copy and paste it.

[#3 · Accepted solution]

Perhaps your list separator is not comma (e.g. semicolon). You may check Win+R type control international and here is under Additional settings

[#4]

@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).

[#5]

---

@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 

[#6]

i already did it but as @Sergei Baklan said it was about typing semicolons instead of commas, but thanks anyway@Twifoo 

[#7]

@thomasea , glad to help

[#8]

Should I put semicolon instead of coma

[#9]

@Najeebibnu 

Depends on your regional settings. Please check here

if you are on Windows.

[#10]

@Sergei Baklan Thank you! That was my issue on my Mac. I had to reset those OS default system settings. Thanks!

[#11]

I have changed this setting to comma ( , ) for list separator, restarted PC, and closed/reopened Excel and still same error as thomasea. Everything written manually from scratch by myself.

[#12]

@JakobNilssonTVV 

Could you please share sample workbook or at least screenshot to illustrate an issue?

[#13]

Thank you but turns out it was the language. Found no other way than to use Swedish formulas instead. @Sergei Baklan