Forum Discussion

thomasea's avatar
thomasea
Copper Contributor
Mar 20, 2019

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 ...
Excel
Formulas and Functions
if
simple
  • SergeiBaklan's avatar
    SergeiBaklan
    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

SergeiBaklan's avatar
SergeiBaklan
MVP
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's avatar
    JakobNilssonTVV
    Copper Contributor
    Feb 22, 2023

    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's avatar
      SergeiBaklan
      MVP
      Mar 01, 2023

      JakobNilssonTVV 

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

      • JakobNilssonTVV's avatar
        JakobNilssonTVV
        Copper Contributor
        Mar 03, 2023

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

  • thomasea's avatar
    thomasea
    Copper Contributor
    Mar 20, 2019

     

    SergeiBaklan 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 SergeiBaklan 

Resources