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

thomasea's avatar
thomasea
Copper Contributor
Mar 20, 2019

i already did it but as SergeiBaklan said it was about typing semicolons instead of commas, but thanks anywayTwifoo 

Najeebibnu's avatar
Najeebibnu
Copper Contributor
Sep 30, 2021
Should I put semicolon instead of coma
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 30, 2021

    Najeebibnu 

    Depends on your regional settings. Please check here

    if you are on Windows.

     

    • abdulbasith29's avatar
      abdulbasith29
      Copper Contributor
      Jun 15, 2023

      Hi, i have the same issue with the IF statement while using ('') and my list separator already is comma(,). How can i get it done SergeiBaklan 

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Jun 15, 2023

        abdulbasith29 

        Most probably something is wrong with text you entered. For example, such error

        if to use two single quotes ' as '' .

        If text was entered correctly (with double quote character "), formula works

        It could be something else, but such things better to discuss having sample file.

    • Lucazrml's avatar
      Lucazrml
      Copper Contributor
      Sep 20, 2022

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

Resources