Working with Functions on French Computer

[Cazzy123]

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

 

[Niek Otten]

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

In Tools>Options>International 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 here:

http://members.chello.nl/jvolk/keepitcool/files/TranslateIT.zip

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Cazzy123]

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]

Try this standalone function translator:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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 Tools>Options>International 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 here:
| >
| > http://members.chello.nl/jvolk/keepitcool/files/TranslateIT.zip
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | 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
| >
| >
| >