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

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

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

Try this standalone function translator:

http://www.applewood.nl/forms/3000/FRM-004/index.asp

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Cazzy123" wrote in message ...
| 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
|
|
|