Different Language Settings...
 

Dear All

What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.

=COUNTIF(A1:A10,"=true")

Does the workbook remain in the English language, or convert to the local
language?

Thanks

Trevor Williams

Different Language Settings...
 

Use it like this

=COUNTIF(A1:A10,TRUE)

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

And all your TRUE's are Waar in the Cells so the formula still work


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Dear All

What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.

=COUNTIF(A1:A10,"=true")

Does the workbook remain in the English language, or convert to the local
language?

Thanks

Trevor Williams

Different Language Settings...
 

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Use it like this

=COUNTIF(A1:A10,TRUE)

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

And all your TRUE's are Waar in the Cells so the formula still work


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Dear All

What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.

=COUNTIF(A1:A10,"=true")

Does the workbook remain in the English language, or convert to the local
language?

Thanks

Trevor Williams

Different Language Settings...
 

Hi Ron, thanks for the response.
Just for clarification re your last note, Excel will automatically translate
the COUNTIF function too.

Thanks again

Trevor

"Ron de Bruin" wrote:

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Use it like this

=COUNTIF(A1:A10,TRUE)

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

And all your TRUE's are Waar in the Cells so the formula still work


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Dear All

What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.

=COUNTIF(A1:A10,"=true")

Does the workbook remain in the English language, or convert to the local
language?

Thanks

Trevor Williams

Different Language Settings...
 

Yes

Also the , will be automatic ;

Only ATP (Analysis ToolPak) functions will not translate
For example Weeknum

This is different in Excel 2007 because the ATP functions are a part of the
default Excel worksheet functions

See this page if you want to know about another problem
http://www.rondebruin.nl/atp.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Hi Ron, thanks for the response.
Just for clarification re your last note, Excel will automatically translate
the COUNTIF function too.

Thanks again

Trevor

"Ron de Bruin" wrote:

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Use it like this

=COUNTIF(A1:A10,TRUE)

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

And all your TRUE's are Waar in the Cells so the formula still work


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Dear All

What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.

=COUNTIF(A1:A10,"=true")

Does the workbook remain in the English language, or convert to the local
language?

Thanks

Trevor Williams

Different Language Settings...
 

excellent. Cheers.

Trevor

"Ron de Bruin" wrote:

Yes

Also the , will be automatic ;

Only ATP (Analysis ToolPak) functions will not translate
For example Weeknum

This is different in Excel 2007 because the ATP functions are a part of the
default Excel worksheet functions

See this page if you want to know about another problem
http://www.rondebruin.nl/atp.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Hi Ron, thanks for the response.
Just for clarification re your last note, Excel will automatically translate
the COUNTIF function too.

Thanks again

Trevor

"Ron de Bruin" wrote:

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
Use it like this

=COUNTIF(A1:A10,TRUE)

In Dutch for example it will be

=COUNTIF(A1:A10;WAAR)

And all your TRUE's are Waar in the Cells so the formula still work


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trevor Williams" wrote in message
...
Dear All

What happens to TRUE/FALSE responses if a workbook created on an English
language pc is used on another langauge pc? - particularly in formulae e.g.

=COUNTIF(A1:A10,"=true")

Does the workbook remain in the English language, or convert to the local
language?

Thanks

Trevor Williams