Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
correct the formulas in the help on line (replace commas by semicolons).
indeed the functions do not work because of this mistake e.g. the SOMME (in french, for SUM) function argument has separators as coma, and should be semi colon |
#2
![]() |
|||
|
|||
![]()
IS this a question or a statement?
-- HTH RP (remove nothere from the email address if mailing direct) "sergeK" wrote in message ... correct the formulas in the help on line (replace commas by semicolons). indeed the functions do not work because of this mistake e.g. the SOMME (in french, for SUM) function argument has separators as coma, and should be semi colon |
#3
![]() |
|||
|
|||
![]()
As I understand it, the separator for function arguments is:
1) a comma for county version where the decimal separator in numbers is a period, and 2) a semi-colon for local version where the comma is used as the decimal separator in numbers So in France one-and-a-half Francs is written as 1,50, so semi-colons are used in functions but in UK, US, Canada, Australia, NewZeeland etc where we write 1.50 then commas are used in function. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "sergeK" wrote in message ... correct the formulas in the help on line (replace commas by semicolons). indeed the functions do not work because of this mistake e.g. the SOMME (in french, for SUM) function argument has separators as coma, and should be semi colon |
#4
![]() |
|||
|
|||
![]()
"Bernard Liengme" wrote...
.... used in functions but in UK, US, Canada, Australia, NewZeeland etc where we write 1.50 then commas are used in function. .... Aussi en Québec? |
#5
![]() |
|||
|
|||
![]()
Pardonez moi! I did not want to get into domestic problems!
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Harlan Grove" wrote in message ... "Bernard Liengme" wrote... ... used in functions but in UK, US, Canada, Australia, NewZeeland etc where we write 1.50 then commas are used in function. ... Aussi en Québec? |
#6
![]() |
|||
|
|||
![]()
Pardonnez-moi? :-)
"Bernard Liengme" wrote in message ... Pardonez moi! I did not want to get into domestic problems! |
#7
![]() |
|||
|
|||
![]()
Bob Phillips wrote...
Pardonnez-moi? :-) Qu=E9b=E9cois, pas fran=E7ais? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to update functions in excel sheet? | Excel Worksheet Functions | |||
Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
How do I add a reference line to Excel charts? | Charts and Charting in Excel | |||
goal line in excel chart | Charts and Charting in Excel | |||
What is the easiest way to learn math functions in excel . | Excel Worksheet Functions |