Jun 04 2020 04:04 AM
Hi
I have been using excel for years and never encountered this problem
A simple calculation that will just not work?
You can see the numbers are correct and will calculate in a cell directly but when the calculation is done using an if statement it will not work.
i have checked that the options box is ticked for automatic and number formats etc.
The simple if statement is =if(a>b, "Y","N) or any thing similar?
Jun 04 2020 04:27 AM
Instead of screenshot it's better to have sample file, otherwise we could discuss for a long while are separators comma or semicolons and other variants.
Jun 04 2020 05:03 AM
I have just discovered that the separator needs to be ; instead of a , which i have always used before.
I assume there is some tick box in the options which has changed ,have to have a look
IF(H2>I2;1;2) |
works
Jun 04 2020 05:11 AM
That's a list separator in Windows settings
Win+R control international Advanced settings
Jun 05 2020 11:10 AM
Jun 05 2020 11:19 AM