Obtaining a numeric value from comparison of a bookmark to text st

B

Bill Benson

I have a bookmark called Gen_Exists in which the value will be either Yes or
No.

I want to use this bookmark in a calculated field as follows:

{=100* {Gen_Exists} = "Yes" }

but I get

!Syntax Error, {

What is the appropriate syntax to multiply 100 x 1 if the string value of
the bookmark Gen_Exists = "Yes" and x 0 if the string value of the bookmark
Gen_Exists <> "Yes"

?
 

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

Similar Threads

Pasting a cell into bookmarked table from excel vba 1
Showing Value, not bookmark name. 1
Field Code : get bookmark (text) without table format 5
Logical tests between Word form text fields 1
I want to calculate a date 1 year ahead of a date in a bookmark 2
IF Field expression not working 2
How do I edit a the contents of bookmark without deleting the book 3
Word macro that can call cells out of Excel for a find and replace 0

Top