Functions parameters separator

  • Thread starter Thread starter Jean Luc
  • Start date Start date
J

Jean Luc

Hi,

Can somebody help me on the following ? (Excel 2002
English)

Help shows parameters separated by a coma
Example :
SUMIF(range,criteria,sum_range)

However,when I use functions I have to separate parameters
by semicolons (";") instead of comas.
Example :
SUMIF(A1:A10;>100;B1:B10)

1. Can we change this ?
2. If we cannot : I meet problems if I want to use a not
consecutive range (example A1;A3;A5). There is a confusion
between the semicolons separating reférences of non-
consecutive cells, and the semicolon separating the
function parameters. This leads to an error.

Can somebody help me on this ?
Many thanks and best regards,

Jean Luc
 
Hi Jean Luc!

If you want comma separators for arguments, you will need to change
your Regional Settings. (Try US or UK)

The trouble is that you have settings that use the comma for the
decimal point and with that setting Excel has to use a different
argument separator because of potential of confusion where numeric
inputs are involved.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Hi,

Can somebody help me on the following ? (Excel 2002
English)

Help shows parameters separated by a coma
Example :
SUMIF(range,criteria,sum_range)

However,when I use functions I have to separate parameters
by semicolons (";") instead of comas.
Example :
SUMIF(A1:A10;>100;B1:B10)

1. Can we change this ?
2. If we cannot : I meet problems if I want to use a not
consecutive range (example A1;A3;A5). There is a confusion
between the semicolons separating reférences of non-
consecutive cells, and the semicolon separating the
function parameters. This leads to an error.

Can somebody help me on this ?
Many thanks and best regards,

Jean Luc
 
Hi Jean-Luc

Those changes are made in Windows' Control Panel, Regional settings. If you
change list separator from semicolon to comma, make also sure you change the
decimal separator from comma to something else too. The settings will affect
all programs on your computer.

I prefer to let Excel translate the functions for me instead, by pasting the
english equivalent into a box like this:

Sub EnterEnglishFormula()
On Error Resume Next
ActiveCell.Formula = _
Trim$(InputBox("English formula:"))
End Sub

Now commas become semicolons, dots become commas and SUMIF is translated to
whatever the local version understands.
--
HTH. Best wishes Harald
Followup to newsgroup only please

"Jean Luc" <[email protected]> skrev i melding
Hi,

Can somebody help me on the following ? (Excel 2002
English)

Help shows parameters separated by a coma
Example :
SUMIF(range,criteria,sum_range)

However,when I use functions I have to separate parameters
by semicolons (";") instead of comas.
Example :
SUMIF(A1:A10;>100;B1:B10)

1. Can we change this ?
2. If we cannot : I meet problems if I want to use a not
consecutive range (example A1;A3;A5). There is a confusion
between the semicolons separating reférences of non-
consecutive cells, and the semicolon separating the
function parameters. This leads to an error.

Can somebody help me on this ?
Many thanks and best regards,

Jean Luc
 
Back
Top