Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formula in word 2003
create a formula in a word form.
I have a situation where I ned to provide an auto response based on the number d in a bokmarked cell "Risk1" I have tried the following but it brings up an error {if { risk1 } ="4""YES"}{if {risk1}"4""10""Stop"}{if{risk1}"9""17""Report" } The basic requirement is to provide a different response based on a number value in form field bookmark "Risk1" which can range between 1-4, 5-9, 10-16 and 17-25 each of the above ranges need a differing response. Help please! -- Regards Martin D |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formula in word 2003
Hi Martin,
You can get the result that you want by creating nested IF fields as follows. {IF {risk1} 1 "{IF {risk1} 4 "YES" "{IF {risk1} 9 "Stop" "{IF {risk1} 17 "Report" "{IF {risk1} 25 "17-25 range" "Not in any range"}"}"}"}" ""} Do not type any of the curly brackets ({}). Create each pair by selecting what will be enclosed by them and pressing Ctrl+F9. Since you didn't give the text for the 17-25 range, I inserted the text "17-25 range", but you can replace it by your text. -- Hope this helps, Pesach Shelnitz My Web site: http://makeofficework.com "Martin D" wrote: create a formula in a word form. I have a situation where I ned to provide an auto response based on the number d in a bokmarked cell "Risk1" I have tried the following but it brings up an error {if { risk1 } ="4""YES"}{if {risk1}"4""10""Stop"}{if{risk1}"9""17""Report" } The basic requirement is to provide a different response based on a number value in form field bookmark "Risk1" which can range between 1-4, 5-9, 10-16 and 17-25 each of the above ranges need a differing response. Help please! -- Regards Martin D |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formula in word 2003
Pesach,
Not sure that this covers everything, perhaps if I use laymans terms it may be clearer. If Risk1 is less than or equal to 4 then return YES If Risk1 is greater than 4 and less than 10 return STOP If Risk1 is greater than 9 and less than 17 return REPORT If Risk1 is greater than 17 return RANGE -- Regards Martin D "Pesach Shelnitz" wrote: Hi Martin, You can get the result that you want by creating nested IF fields as follows. {IF {risk1} 1 "{IF {risk1} 4 "YES" "{IF {risk1} 9 "Stop" "{IF {risk1} 17 "Report" "{IF {risk1} 25 "17-25 range" "Not in any range"}"}"}"}" ""} Do not type any of the curly brackets ({}). Create each pair by selecting what will be enclosed by them and pressing Ctrl+F9. Since you didn't give the text for the 17-25 range, I inserted the text "17-25 range", but you can replace it by your text. -- Hope this helps, Pesach Shelnitz My Web site: http://makeofficework.com "Martin D" wrote: create a formula in a word form. I have a situation where I ned to provide an auto response based on the number d in a bokmarked cell "Risk1" I have tried the following but it brings up an error {if { risk1 } ="4""YES"}{if {risk1}"4""10""Stop"}{if{risk1}"9""17""Report" } The basic requirement is to provide a different response based on a number value in form field bookmark "Risk1" which can range between 1-4, 5-9, 10-16 and 17-25 each of the above ranges need a differing response. Help please! -- Regards Martin D |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formula in word 2003
Hi Martin,
In this case, a few changes are needed. {IF {Risk1} = 1 "{IF {Risk1} = 4 "YES" "{IF {Risk1} = 9 "STOP" "{IF {Risk1} = 17 "REPORT" "RANGE"}"}"}"} -- Hope this helps, Pesach Shelnitz My Web site: http://makeofficework.com "Martin D" wrote: Pesach, Not sure that this covers everything, perhaps if I use laymans terms it may be clearer. If Risk1 is less than or equal to 4 then return YES If Risk1 is greater than 4 and less than 10 return STOP If Risk1 is greater than 9 and less than 17 return REPORT If Risk1 is greater than 17 return RANGE -- Regards Martin D "Pesach Shelnitz" wrote: Hi Martin, You can get the result that you want by creating nested IF fields as follows. {IF {risk1} 1 "{IF {risk1} 4 "YES" "{IF {risk1} 9 "Stop" "{IF {risk1} 17 "Report" "{IF {risk1} 25 "17-25 range" "Not in any range"}"}"}"}" ""} Do not type any of the curly brackets ({}). Create each pair by selecting what will be enclosed by them and pressing Ctrl+F9. Since you didn't give the text for the 17-25 range, I inserted the text "17-25 range", but you can replace it by your text. -- Hope this helps, Pesach Shelnitz My Web site: http://makeofficework.com "Martin D" wrote: create a formula in a word form. I have a situation where I ned to provide an auto response based on the number d in a bokmarked cell "Risk1" I have tried the following but it brings up an error {if { risk1 } ="4""YES"}{if {risk1}"4""10""Stop"}{if{risk1}"9""17""Report" } The basic requirement is to provide a different response based on a number value in form field bookmark "Risk1" which can range between 1-4, 5-9, 10-16 and 17-25 each of the above ranges need a differing response. Help please! -- Regards Martin D |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formula in word 2003
Hi Martin,
Try: {IF{Risk1} 17 "RANGE" {IF{Risk1} 10 "REPORT" {IF{Risk1} 4 "STOP" "YES"}}} If 'Risk1' is a dropdown formfield's bookmark, you'll need to use: {IF{REF Risk1} 17 "RANGE" {IF{REF Risk1} 10 "REPORT" {IF{REF Risk1} 4 "STOP" "YES"}}} -- Cheers macropod [Microsoft MVP - Word] "Martin D" wrote in message ... Pesach, Not sure that this covers everything, perhaps if I use laymans terms it may be clearer. If Risk1 is less than or equal to 4 then return YES If Risk1 is greater than 4 and less than 10 return STOP If Risk1 is greater than 9 and less than 17 return REPORT If Risk1 is greater than 17 return RANGE -- Regards Martin D "Pesach Shelnitz" wrote: Hi Martin, You can get the result that you want by creating nested IF fields as follows. {IF {risk1} 1 "{IF {risk1} 4 "YES" "{IF {risk1} 9 "Stop" "{IF {risk1} 17 "Report" "{IF {risk1} 25 "17-25 range" "Not in any range"}"}"}"}" ""} Do not type any of the curly brackets ({}). Create each pair by selecting what will be enclosed by them and pressing Ctrl+F9. Since you didn't give the text for the 17-25 range, I inserted the text "17-25 range", but you can replace it by your text. -- Hope this helps, Pesach Shelnitz My Web site: http://makeofficework.com "Martin D" wrote: create a formula in a word form. I have a situation where I ned to provide an auto response based on the number d in a bokmarked cell "Risk1" I have tried the following but it brings up an error {if { risk1 } ="4""YES"}{if {risk1}"4""10""Stop"}{if{risk1}"9""17""Report" } The basic requirement is to provide a different response based on a number value in form field bookmark "Risk1" which can range between 1-4, 5-9, 10-16 and 17-25 each of the above ranges need a differing response. Help please! -- Regards Martin D |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formula in word 2003
worked very well and a little simpler than the previous posting.
Is it possible to change the colour of the formula cell based on the number in Risk1: 4 yellow 9 Amber 17 Red else GREEN -- Regards Martin D "macropod" wrote: Hi Martin, Try: {IF{Risk1} 17 "RANGE" {IF{Risk1} 10 "REPORT" {IF{Risk1} 4 "STOP" "YES"}}} If 'Risk1' is a dropdown formfield's bookmark, you'll need to use: {IF{REF Risk1} 17 "RANGE" {IF{REF Risk1} 10 "REPORT" {IF{REF Risk1} 4 "STOP" "YES"}}} -- Cheers macropod [Microsoft MVP - Word] "Martin D" wrote in message ... Pesach, Not sure that this covers everything, perhaps if I use laymans terms it may be clearer. If Risk1 is less than or equal to 4 then return YES If Risk1 is greater than 4 and less than 10 return STOP If Risk1 is greater than 9 and less than 17 return REPORT If Risk1 is greater than 17 return RANGE -- Regards Martin D "Pesach Shelnitz" wrote: Hi Martin, You can get the result that you want by creating nested IF fields as follows. {IF {risk1} 1 "{IF {risk1} 4 "YES" "{IF {risk1} 9 "Stop" "{IF {risk1} 17 "Report" "{IF {risk1} 25 "17-25 range" "Not in any range"}"}"}"}" ""} Do not type any of the curly brackets ({}). Create each pair by selecting what will be enclosed by them and pressing Ctrl+F9. Since you didn't give the text for the 17-25 range, I inserted the text "17-25 range", but you can replace it by your text. -- Hope this helps, Pesach Shelnitz My Web site: http://makeofficework.com "Martin D" wrote: create a formula in a word form. I have a situation where I ned to provide an auto response based on the number d in a bokmarked cell "Risk1" I have tried the following but it brings up an error {if { risk1 } ="4""YES"}{if {risk1}"4""10""Stop"}{if{risk1}"9""17""Report" } The basic requirement is to provide a different response based on a number value in form field bookmark "Risk1" which can range between 1-4, 5-9, 10-16 and 17-25 each of the above ranges need a differing response. Help please! -- Regards Martin D . |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Formula in word 2003
You can colour the words in the field as required but if you want the
background of the containing cell coloured you are going to need a macro. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Martin D" wrote in message ... worked very well and a little simpler than the previous posting. Is it possible to change the colour of the formula cell based on the number in Risk1: 4 yellow 9 Amber 17 Red else GREEN -- Regards Martin D "macropod" wrote: Hi Martin, Try: {IF{Risk1} 17 "RANGE" {IF{Risk1} 10 "REPORT" {IF{Risk1} 4 "STOP" "YES"}}} If 'Risk1' is a dropdown formfield's bookmark, you'll need to use: {IF{REF Risk1} 17 "RANGE" {IF{REF Risk1} 10 "REPORT" {IF{REF Risk1} 4 "STOP" "YES"}}} -- Cheers macropod [Microsoft MVP - Word] "Martin D" wrote in message ... Pesach, Not sure that this covers everything, perhaps if I use laymans terms it may be clearer. If Risk1 is less than or equal to 4 then return YES If Risk1 is greater than 4 and less than 10 return STOP If Risk1 is greater than 9 and less than 17 return REPORT If Risk1 is greater than 17 return RANGE -- Regards Martin D "Pesach Shelnitz" wrote: Hi Martin, You can get the result that you want by creating nested IF fields as follows. {IF {risk1} 1 "{IF {risk1} 4 "YES" "{IF {risk1} 9 "Stop" "{IF {risk1} 17 "Report" "{IF {risk1} 25 "17-25 range" "Not in any range"}"}"}"}" ""} Do not type any of the curly brackets ({}). Create each pair by selecting what will be enclosed by them and pressing Ctrl+F9. Since you didn't give the text for the 17-25 range, I inserted the text "17-25 range", but you can replace it by your text. -- Hope this helps, Pesach Shelnitz My Web site: http://makeofficework.com "Martin D" wrote: create a formula in a word form. I have a situation where I ned to provide an auto response based on the number d in a bokmarked cell "Risk1" I have tried the following but it brings up an error {if { risk1 } ="4""YES"}{if {risk1}"4""10""Stop"}{if{risk1}"9""17""Report" } The basic requirement is to provide a different response based on a number value in form field bookmark "Risk1" which can range between 1-4, 5-9, 10-16 and 17-25 each of the above ranges need a differing response. Help please! -- Regards Martin D . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Word 2003 table formula | Tables | |||
Formula for Word 2003 Table | Tables | |||
condition formula in Word 2003 | Microsoft Word Help | |||
How to Find microsoft word new formula 2003 | New Users | |||
Word 2003 Table cell formula | Tables |