A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"AND" (compound conditions)



 
 
Thread Tools Display Modes
  #11  
Old November 9th, 2004, 02:06 PM
Monika Krug
external usenet poster
 
Posts: n/a
Default

"Peter Jamieson" wrote:

Monika Krug wrote:

A note: In your tutorial you write e.g. AND(x,y). I have
tried this and I get a syntax error. It only worked

with ;
instead of ,.


This is almost certainly because of differences in

regional settings.
English USA, UK and probably elsewhere use comma as a

list separator whereas
e.g. German (Germany) uses semi-colon.


Thank you, this must be the explanation. The regional
settings of my PC are set to German. (The PC with Word
2002 where ; worked must have been set to English.)

Monika.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
using SUMIF function with compound conditions agarwaldvk Worksheet Functions 12 August 10th, 2004 12:23 AM
compound index taccea Running & Setting Up Queries 4 July 15th, 2004 05:44 AM
Averaging compound numbers Old Red One General Discussion 4 June 14th, 2004 12:06 PM
calculate compound growth Peter Atherton Worksheet Functions 1 March 3rd, 2004 04:25 PM
compound sum interest factor function? joeleandri Worksheet Functions 5 November 26th, 2003 07:28 PM


All times are GMT +1. The time now is 09:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.