Hi Niek,

Thanks for that, unfortunately my system will not allow me to open the link,
I presume because it has macros. Any ideas of another way I can access it?

Caz

"Niek Otten" wrote:

Probably you need a semicolon as list separator instead of a comma; =SI(A1=1;2;1000)

In ToolsOptionsInternational tab you can choose to not use the system separators. Maybe that makes things easier for you to
start with.
Of course you can change Windows' separators too. But then your system is hardly French anymore...:-)

An add-in for translation of functions can be found he

http://members.chello.nl/jvolk/keepi...ranslateIT.zip

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Cazzy123" wrote in message ...
| Hi,
|
| I have just bought a French computer and can't get the simplest of formula's
| to work. I am trying to do an IF or Si statement but it won't work but if I
| use the same formula on my UK laptop it is fine.
|
| Is this because characters such as () and " or the <and are different on
| the French system? If so can someone guide me to a site where I can find the
| differences.
|
| Thanks