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
.