If fields for comparison

  • Thread starter Thread starter theresaluff
  • Start date Start date
T

theresaluff

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

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top