Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

Different Language Settings...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Trevor Williams - 06 May 2008 10:18 GMT
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
Ron de Bruin - 06 May 2008 14:14 GMT
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

Signature

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

> Dear All
>
[quoted text clipped - 9 lines]
>
> Trevor Williams
Ron de Bruin - 06 May 2008 14:19 GMT
> In Dutch for example it will be
>
> =COUNTIF(A1:A10;WAAR)

Must be

=AANTAL.ALS(A1:A10;WAAR)

Signature

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

> Use it like this
>
[quoted text clipped - 19 lines]
>>
>> Trevor Williams
Trevor Williams - 06 May 2008 14:32 GMT
Hi Ron, thanks for the response.
Just for clarification re your last note, Excel will automatically translate
the COUNTIF function too.

Thanks again

Trevor

> > In Dutch for example it will be
> >
[quoted text clipped - 27 lines]
> >>
> >> Trevor Williams
Ron de Bruin - 06 May 2008 14:40 GMT
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

Signature

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

> Hi Ron, thanks for the response.
> Just for clarification re your last note, Excel will automatically translate
[quoted text clipped - 35 lines]
>> >>
>> >> Trevor Williams
Trevor Williams - 06 May 2008 15:00 GMT
excellent.  Cheers.

Trevor

> Yes
>
[quoted text clipped - 48 lines]
> >> >>
> >> >> Trevor Williams
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.