excel calculation error

[kingdom42]

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?

[#2]

@kingdom42 

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.

[#3]

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

[#4]

@kingdom42 

That's a list separator in Windows settings

Win+R control international Advanced settings

[#5]

Thanks
I am going to add a new post showing another problem

[#6]

I believe the problem may be connected with the fact that I exported a csv file from another program and then used the data on the sheet for some calculations Even after I saved the file as a workbook .xls the problem persists.
For example two numbers £24,86 and -£20 wen added show as £4860.
Nothing I do in the format options will change that and it defaults to "Custom" even after i select "Currency"
I have a screen shot which I will try to attach not sure if I can do that.

is it possible that using a CSV file could alter the excel settings?
regards