Forum Discussion

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

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
Diamond Contributor
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
    Diamond Contributor
    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.

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

      It works now. I got a hint from your reply. Actually when i press the double quote's ('')button, it actually is a single quote only, but it comes twice at the same time (I thought this is real double quote). But when i press it with SHIFT button, the real double quote appeared (""). So now it is working. Thank you so much SergeiBaklan 

       

       

Resources