IF Fields With AND Statements

[Brendan Vassallo]

I am trying to write an IF AND statement in Word 2003.

What I am trying to do is if my Form Field "Text52" is grater than 35 and
les than 50 I would like to return the text "True" otherwise I want to return
the text "False"

Can anyone please help me on how to do this as I have been trying to do it
for 3 days and I am out of ideas.

Thanks in advance

 

[Greg Maxey]

Brendan,

Like this:
{ IF { TEXT52 } >"35"{ IF { TEXT52 }<"50""True""False" }"False"}
make sure that "Calculate on Exit" is checked in your Formfield52 setup
dialog.

 

[Brendan Vassallo]

Greg,

Thanks for your reply

This does not work....it gives me a blank field. I am trying to use a TEXT
Form Field calculation to do this. I already had the calculate on exit set
up dialog on in Text52. From what I have read in Word Help I think I require
and AND statement and maybe a COMPARE statement.

Do you have any other ideas?

I hope you do cause i am getting a little frustrated with this...lol

 

[Greg Maxey]

Brendan,

It worked here when I tested it. AFAIK there is no way to get literal text
"True" or "False" out of a calculation field.

You could use { =If(And({ Test }>35,{ Test }<50),1,0) } in a calculation
field to return 1 for True and 0 for False. Note: Replace Test with your
Text52 field.

Then stick that in an IF field

{ IF { =If(And({ Test }>35,{ Test }<50),1,0) } = "1""True""False"}

I still thing my first suggestion is best. Don't put it it a calculation
field. Enter it directly in the document.

 

[Brendan Vassallo]

Greg,

I got it to work with your initial solution.....you are a legend....thank
you so much for your help, I really appreciate it.

Take Care