Populate one cell with words depending on the value of another cell

[ThomasBrown]

Hi there,

What I am trying to do I think is simple but have come acccross a bit of a block ... any help would be appreciated.


I have column A which will have values between 1-70
Then I need to populate column B
If the value in Column A is between 1 - 9 - then Column B must say 'None'
If the value in Column A is between 10 - 19 - then Column B must say 'Poor'
If the value in Column A is between 20 - 34 - then Column B must say 'Average' etc.

There are 5 values in Total

Many Thanks
Thomas

 

[ThomasBrown]

Hi All,

It came back to me and I have done it.

The formula looks like this:
=IF(D6<10,"None",IF(D6<20,"Poor",IF(D6<35,"Average","")))

Regards
Thomas

 

[SkipVought]

Hi,

first build a lookup table
[tt]
LowerValue Category
1 None
10 Poor
20 Average
...
[/tt]
I use Named Ranges. faq68-1331

The formula, assuming that A1 contains a score (1 - 70)
[tt]
=INDEX(Category,MATCH(A1,LowerValue,1),1)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]