Forum Discussion

stchambers's avatar
stchambers
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
stchambers's avatar
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's avatar
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's avatar
    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!

Resources