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 b...
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- 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
