Formula in word 2003

[Martin D]

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!

 

[Pesach Shelnitz]

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.

 

[Martin D]

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

 

[Pesach Shelnitz]

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"}"}"}"}

 

[macropod]

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"}}}

 

[Martin D]

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

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]

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

.

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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

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]

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


:

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


:

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!

.