Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |