Forum Discussion
excel calculation error
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?
5 Replies
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
- Thanks
I am going to add a new post showing another problem
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.
