(Msg. 1) Posted: Wed Aug 06, 2008 1:50 pm
Post subject: Working with Functions on French Computer Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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.
(Msg. 2) Posted: Wed Aug 06, 2008 11:35 pm
Post subject: Re: Working with Functions on French Computer [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
"Cazzy123" <Cazzy123.DeleteThis@discussions.microsoft.com> wrote in message news:10B8915F-D13E-4A86-8BF9-9AFE827CB0FB@microsoft.com...
| 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
(Msg. 3) Posted: Wed Aug 06, 2008 11:35 pm
Post subject: Re: Working with Functions on French Computer [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>
> "Cazzy123" <Cazzy123 DeleteThis @discussions.microsoft.com> wrote in message news:10B8915F-D13E-4A86-8BF9-9AFE827CB0FB@microsoft.com...
> | 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
>
>
>
(Msg. 4) Posted: Thu Aug 07, 2008 12:17 pm
Post subject: Re: Working with Functions on French Computer [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Cazzy123" <Cazzy123.RemoveThis@discussions.microsoft.com> wrote in message news:131F7183-3600-4335-956A-3BC4DE0805F4@microsoft.com...
| 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
| >
| > "Cazzy123" <Cazzy123.RemoveThis@discussions.microsoft.com> wrote in message news:10B8915F-D13E-4A86-8BF9-9AFE827CB0FB@microsoft.com...
| > | 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
| >
| >
| >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office