Forum Discussion
thomasea
Mar 20, 2019Copper Contributor
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
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 ...
- Mar 20, 2019
Perhaps your list separator is not comma (e.g. semicolon). You may check Win+R type control international and here is under Additional settings
JakobNilssonTVV
Feb 22, 2023Copper Contributor
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.
SergeiBaklan
Mar 01, 2023MVP
Could you please share sample workbook or at least screenshot to illustrate an issue?
- JakobNilssonTVVMar 03, 2023Copper Contributor
Thank you but turns out it was the language. Found no other way than to use Swedish formulas instead. SergeiBaklan