Reply
 
Thread Tools Display Modes
  #1   Report Post  
Brendan Vassallo
 
Posts: n/a
Default IF Fields With AND Statements

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
  #2   Report Post  
Greg Maxey
 
Posts: n/a
Default

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.


--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Brendan Vassallo wrote:
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



  #3   Report Post  
Brendan Vassallo
 
Posts: n/a
Default

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" wrote:

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.


--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Brendan Vassallo wrote:
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




  #4   Report Post  
Greg Maxey
 
Posts: n/a
Default

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.



--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Brendan Vassallo wrote:
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" wrote:

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.


--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Brendan Vassallo wrote:
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



  #5   Report Post  
Brendan Vassallo
 
Posts: n/a
Default

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

"Greg Maxey" wrote:

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.



--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Brendan Vassallo wrote:
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" wrote:

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.


--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Brendan Vassallo wrote:
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




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 07:39 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"