Why do functions not allow commas to seperate arguments

[JohanS]

Has anyone seen this before?

Functions are normally entered as =if(a2>10,"True","False")
My excel is not accepting formulas typed in this format, but rather shows me
the following when using the wizard: (not commas between arguments, but a
single space) IF(logical_test value_if_true value_if_false)
Even when using the wizard, it still returns error:
The formula you typed contains an error (same if I enter commas)

[Ron de Bruin]

Hi Johan

This depend on the regional settings of your system.
If I use a Dutch machine I must use ;
And if I use a English machine ,

You can change it if you want in the regional settings tab on the
Windows control panel.





--
Regards Ron de Bruin
http://www.rondebruin.nl


"JohanS" <[email protected]> wrote in message news:[email protected]...
> Has anyone seen this before?
>
> Functions are normally entered as =if(a2>10,"True","False")
> My excel is not accepting formulas typed in this format, but rather shows me
> the following when using the wizard: (not commas between arguments, but a
> single space) IF(logical_test value_if_true value_if_false)
> Even when using the wizard, it still returns error:
> The formula you typed contains an error (same if I enter commas)
>

[Harlan Grove]

JohanS wrote...
....
>Functions are normally entered as =if(a2>10,"True","False")
>My excel is not accepting formulas typed in this format, but rather shows me
>the following when using the wizard: (not commas between arguments, but a
>single space) IF(logical_test value_if_true value_if_false)
>Even when using the wizard, it still returns error:
>The formula you typed contains an error (same if I enter commas)

Somehow your PC's Windows List Separator character has become a space
character. You need to revert it to a comma. Open your Control Panel
(Start Menu > Settings > Control Panel), run the Regional Settings
applet (it may be called Regional and Language Options). Under Windows
XP, you'll need to click on the Customize... button in the Regional
Options tab in the dialog. In older Windows versions there's a tab in
the dialog for Number and Date formats. There's an entry for List
separator. Change it to a comma.

[Łukasz Szczepański]

I have similar problem (I must use ";"), but in regional options I have comma
set up as list separator.
Does it make sense?

Lukasz

"Harlan Grove" wrote:

> JohanS wrote...
> ....
> >Functions are normally entered as =if(a2>10,"True","False")
> >My excel is not accepting formulas typed in this format, but rather shows me
> >the following when using the wizard: (not commas between arguments, but a
> >single space) IF(logical_test value_if_true value_if_false)
> >Even when using the wizard, it still returns error:
> >The formula you typed contains an error (same if I enter commas)
>
> Somehow your PC's Windows List Separator character has become a space
> character. You need to revert it to a comma. Open your Control Panel
> (Start Menu > Settings > Control Panel), run the Regional Settings
> applet (it may be called Regional and Language Options). Under Windows
> XP, you'll need to click on the Customize... button in the Regional
> Options tab in the dialog. In older Windows versions there's a tab in
> the dialog for Number and Date formats. There's an entry for List
> separator. Change it to a comma.
>
>

[Niek Otten]

Tools>Options>International tab, check Use System separators

--
Kind regards,

Niek Otten

"Lukasz Szczepanski" <Lukasz [email protected]> wrote in message
news:[email protected]...
|I have similar problem (I must use ";"), but in regional options I have comma
| set up as list separator.
| Does it make sense?
|
| Lukasz
|
| "Harlan Grove" wrote:
|
| > JohanS wrote...
| > ....
| > >Functions are normally entered as =if(a2>10,"True","False")
| > >My excel is not accepting formulas typed in this format, but rather shows me
| > >the following when using the wizard: (not commas between arguments, but a
| > >single space) IF(logical_test value_if_true value_if_false)
| > >Even when using the wizard, it still returns error:
| > >The formula you typed contains an error (same if I enter commas)
| >
| > Somehow your PC's Windows List Separator character has become a space
| > character. You need to revert it to a comma. Open your Control Panel
| > (Start Menu > Settings > Control Panel), run the Regional Settings
| > applet (it may be called Regional and Language Options). Under Windows
| > XP, you'll need to click on the Customize... button in the Regional
| > Options tab in the dialog. In older Windows versions there's a tab in
| > the dialog for Number and Date formats. There's an entry for List
| > separator. Change it to a comma.
| >
| >

[Łukasz Szczepański]

I had to change Regional Options profile to English (US).
Now it works.

Łukasz

"Niek Otten" wrote:

> Tools>Options>International tab, check Use System separators
>
> --
> Kind regards,
>
> Niek Otten
>
> "Lukasz Szczepanski" <Lukasz [email protected]> wrote in message
> news:[email protected]...
> |I have similar problem (I must use ";"), but in regional options I have comma
> | set up as list separator.
> | Does it make sense?
> |
> | Lukasz
> |
> | "Harlan Grove" wrote:
> |
> | > JohanS wrote...
> | > ....
> | > >Functions are normally entered as =if(a2>10,"True","False")
> | > >My excel is not accepting formulas typed in this format, but rather shows me
> | > >the following when using the wizard: (not commas between arguments, but a
> | > >single space) IF(logical_test value_if_true value_if_false)
> | > >Even when using the wizard, it still returns error:
> | > >The formula you typed contains an error (same if I enter commas)
> | >
> | > Somehow your PC's Windows List Separator character has become a space
> | > character. You need to revert it to a comma. Open your Control Panel
> | > (Start Menu > Settings > Control Panel), run the Regional Settings
> | > applet (it may be called Regional and Language Options). Under Windows
> | > XP, you'll need to click on the Customize... button in the Regional
> | > Options tab in the dialog. In older Windows versions there's a tab in
> | > the dialog for Number and Date formats. There's an entry for List
> | > separator. Change it to a comma.
> | >
> | >
>
>
>