=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!
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/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
--
Cheers
macropod
[MVP - Microsoft Word]
"n_hobbs" <n_h...@discussions.microsoft.com> wrote in message news:9B9573B2-DD49-4A01...@microsoft.com...