Use of IF statements w/ bookmarks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Claudia - 20 Sep 2004 22:25 GMT

I'm having trouble getting an IF statement to work
properly (or it's operator error, I'll concede). This is
the statement:
IF IdahoorFed = Idaho "fifteen (15)" "thirty (30)"

The bookmark IdahoorFed is a dropdown field, with two
choices: Idaho or Federal. My IF statement occurs later
in the paragraph. What I want to happen is if "Idaho" is
chosen, then the result in this field should be "fifteen
(15)", if it's "Federal," then it should state "thirty
(30)". I cannot get it to work. Right now it's
showing "thirty (30)" despite my IF statement. What am I
doing wrong?

Reply to this Message

Peter Jamieson - 21 Sep 2004 05:27 GMT

Try using the bookmark /field/, i.e.

I'd suggest you need some additional quotes at least:

{ IF IdahoorFed = "Idaho" "fifteen (15)" "thirty (30)" }

and I would go for

{ IF { REF IdahoorFed } = "Idaho" "fifteen (15)" "thirty (30)" }

where all the {} are the special field code braces you can insert using
ctrl-F9.

Signature

Peter Jamieson

> I'm having trouble getting an IF statement to work
> properly (or it's operator error, I'll concede). This is
[quoted text clipped - 9 lines]
> showing "thirty (30)" despite my IF statement. What am I
> doing wrong?

Reply to this Message

Rate this thread: