mistakes in the Excel functions (help on line french version at le

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
IS this a question or a statement?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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 Liengme said:
used in functions but in UK, US, Canada, Australia, NewZeeland etc where we
write 1.50 then commas are used in function.
Click to expand...
....

Aussi en Québec?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

French to English translation of the name of an excel function 3
Semi-colon vs Comma in Functions 2
French Version of Excel saving CSV Files with a semi-colon 2
Cells wont calculate in French version 3
using Networkdays formula in French version of Excel options 2
The Help on the Excel Edate worksheet function contains an error:. 1
Data validation in Excel 2007 5
change csv list separator in excel 2007 Dutch version 1

Back
Top