Forum Discussion
MischaKooij
Jan 14, 2020Copper Contributor
Function type and language setting
Good day, When I use e.q. the IF function i need to use ; (Dutch version) for separation instead of , (English version). I was previously working in Office 2010 English setup and recently we upda...
MischaKooij
Jan 14, 2020Copper Contributor
PascalKTeam many thanks for your reply.
The separator is already at ,
Still have the problem that Excel doesn't reckon ; as a ,
should be =if(A1=0,1,2) but still have to use ; thus =if(A1=0;1;2)
PascalKTeam
Jan 14, 2020Iron Contributor
Hmmm I don't know of any other setting than this. Maybe you need to restart Excel after you change the setting or even reboot your PC.