Forum Discussion
stchambers
Feb 06, 2020Copper Contributor
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...
Riny_van_Eekelen
Feb 06, 2020Platinum Contributor
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?