Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sergeK
 
Posts: n/a
Default mistakes in the Excel functions (help on line french version at le

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Harlan Grove
 
Posts: n/a
Default

"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   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

Pardonnez-moi? :-)

"Bernard Liengme" wrote in message
...
Pardonez moi! I did not want to get into domestic problems!




  #7   Report Post  
Harlan Grove
 
Posts: n/a
Default

Bob Phillips wrote...
Pardonnez-moi? :-)


Qu=E9b=E9cois, pas fran=E7ais?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to update functions in excel sheet? Inass Excel Worksheet Functions 1 February 22nd 05 05:14 PM
Lines not visible in an Excel line chart argonaut Charts and Charting in Excel 1 February 18th 05 02:00 AM
How do I add a reference line to Excel charts? roswellmike Charts and Charting in Excel 4 January 2nd 05 01:29 PM
goal line in excel chart Warren Lehndorfer Charts and Charting in Excel 1 December 3rd 04 04:38 PM
What is the easiest way to learn math functions in excel . Harold1955 Excel Worksheet Functions 2 November 4th 04 01:34 AM


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"