Forum Discussion
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 for decades, and they don't get any simpler than these. I don't understand what has changed all of a sudden to cause Excel to behave this way.
Any ideas?
7 Replies
Check which list separator is used for Windows
Win+R, control international, Advance
In formula it shall be the same, usually comma or semicolon.
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!
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).
I think there is something that is more than meet the eyes with regards to the IF function that isn't working over there. The version of Excel you're using is definitely not the cause of the problem.
I will advice you upload the sample file to verify what could be the cause of the problem
I suspect that your local settings require a semi-colon ";" to separate elements in the formula, rather than a comma. Did you perhaps accidentally change these settings?
