[[email protected]]

I am trying to create a table in Word so that when the contents of
certain rows are added the result will produce on of several answers.

Basically,

If result is less than 1 - Poor
If result is greater than 0 but less than 11 - Average
If result is greater than 10 but less than 21 - Good
If result is greater than 21 - Very Good

Firstly, is it possible to do this in Word (I prefer the look of Word
to Excel) and secondly, if so how ?

All help gratefully received

[macropod]

Apart from the fact you've got overlapping ranges, you could code a series of nested IF fields as:
{IF{REF Result} 1 "Poor" {IF{REF Result} 11 "Average" {IF{REF Result} 21 "Good" "Very Good"}}}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

wrote in message oups.com...
I am trying to create a table in Word so that when the contents of
certain rows are added the result will produce on of several answers.

Basically,

If result is less than 1 - Poor
If result is greater than 0 but less than 11 - Average
If result is greater than 10 but less than 21 - Good
If result is greater than 21 - Very Good

Firstly, is it possible to do this in Word (I prefer the look of Word
to Excel) and secondly, if so how ?

All help gratefully received

[Suzanne S. Barnhill]

Look for the example of nested IF fields in the "Specify multiple
conditions" section of the "Examples of IF fields" Help topic.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

wrote in message
oups.com...
I am trying to create a table in Word so that when the contents of
certain rows are added the result will produce on of several answers.

Basically,

If result is less than 1 - Poor
If result is greater than 0 but less than 11 - Average
If result is greater than 10 but less than 21 - Good
If result is greater than 21 - Very Good

Firstly, is it possible to do this in Word (I prefer the look of Word
to Excel) and secondly, if so how ?

All help gratefully received