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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF statement in Word table
I have tried to review all the outstanding comments but I can't seem to get
my IF statement to work. I am trying to reference 1 particular cell in the table that if the value entered is $250 or above that another field displays "SignatureRequired" "NOT Required". I am entering the following IF statment in the field where I want the Signature message to appear. =IF(D6=250,SignatureRequired,NOTRequired) I have tried to bookmark the actual cell/field but it displays as Undefined Bookmark or Syntax Error. I am not familiar with Macros but any assistance would be appreciated (especially if all I have to do is copy and paste ). Thanks! |
#2
|
|||
|
|||
IF statement in Word table
Hi n_hobbs,
Word's formula syntax is rather different from Excel's where text is concerned. For your needs, you could use a formula field coded as: {IF{D6} 250 "Signature Required" "Signature NOT Required"} or {=D6-250 \# "Signature Required;Signature NOT Required;Signature NOT Required"} Alternatively, you you insert 'SignatureRequired' in the cell and use a field coded as either: {IF{D6} 250 " " " NOT "} or: {=D6-250 \# " ; NOT ; NOT "} between the 'Signature' and 'Required'. Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. For more information on doing field calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "n_hobbs" wrote in message ... I have tried to review all the outstanding comments but I can't seem to get my IF statement to work. I am trying to reference 1 particular cell in the table that if the value entered is $250 or above that another field displays "SignatureRequired" "NOT Required". I am entering the following IF statment in the field where I want the Signature message to appear. =IF(D6=250,SignatureRequired,NOTRequired) I have tried to bookmark the actual cell/field but it displays as Undefined Bookmark or Syntax Error. I am not familiar with Macros but any assistance would be appreciated (especially if all I have to do is copy and paste ). Thanks! |
Thread Tools | |
Display Modes | |
|
|