Getting formula syntax right using "OR" - Word 97

J

Jon Gammon

I'm trying deparately to automate a document as follows:

a) I have a bookmark in a template document that will
contain "Sir", "Madam" or a name of a person

b) I want to use the contents of the bookmark to determine
how the letter is signed - the rule is that if the
bookmark is Sir or Madam the letter is signed "Yours
faithfully", if it contains anything else it is
signed "Yours sincerely" (very British I know!)

c) I have tried every which way using the W97 help using
nested formulae with the IF and OR/COMPARE formulae and I
cannot get it to work - keep getting syntax errors. I can
get components to work but not the whole thing.

Can anybody help please!

Jon
 
G

Greg Maxey

Jon

Try:
{If BM = "Sir" "Yours Faithfully" "{If BM = "Madame" "Yours Faithfully"
"Yours Sincerely"}"}

were BM is your bookmark name.

--
\\\\///////////
( @ @ )
----oo00---(_)---00oo----
Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top