Why do functions not allow commas to seperate arguments

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" <JohanS@discussions.microsoft.com> wrote in message news:F83C445B-8E07-47F8-AD62-1C111CBF5758@microsoft.com...
> 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)
>

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.

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)

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" <JohanS@discussions.microsoft.com> wrote in message news:F83C445B-8E07-47F8-AD62-1C111CBF5758@microsoft.com...
> 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)
>

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.