Forum Discussion

Copper Contributor

Feb 06, 2020

Basic IF Statements Not Working

All of a sudden, simple IF statements in Excel 2016 are not working. Examples are attached. It keeps giving me the "There's a problem with this formula" error message. I've used IF statements f...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Feb 06, 2020

stchambers

Check which list separator is used for Windows

Win+R, control international, Advance

In formula it shall be the same, usually comma or semicolon.

stchambers
Copper Contributor
Feb 06, 2020
SergeiBaklan you are exactly right. I had forgotten that I changed that setting the other day to "|", so a CSV file would load correctly.

Thanks for pointing that out. I thought I had lost my mind!
- SergeiBaklan
  Diamond Contributor
  Feb 06, 2020
  stchambers
  
  In CSV file you may define separator in the first line as sep=
  
  Excel opens above file as
  
  (yes, my list separator in the system is comma).
  - stchambers
    Copper Contributor
    Feb 06, 2020
    SergeiBaklan Thanks for that tip! I was able to open my problem CSV file correctly.
    
    The issue was that the file is pipe-delimited, but one of the fields includes a few names that have commas. So with the global setting at ",", Excel would automatically parse those lines.
    
    Thanks again for the help!