Thanks to Chip & Biff. Points taken
Derrick

"Biff" <biffinpitt@comcast.net> wrote in message
news:%232VoCMMZFHA.980@TK2MSFTNGP12.phx.gbl...
> Hi!
>
> Here's one way.
>
> Invert your table, get rid of the "-" and the "=" so that it looks like
> this:
>
> H1..........I1..........J1
> 0.3....... 0.39........ very poor
> 0.4....... 0.49........ poor
> 0.5....... 0.59........ average opportunity
> 0.6....... 0.69........ good
> 0.7....... 0.79........ very good
> 0.8....... 0.89........ excellent opportunity
> 0.9....... 1............. extraordinary opportunity
>
> The table is in the range H1:J7.
>
> Assume your total score is in cell A1. In B1 enter this formula:
>
> =IF(OR(A1="",A1<0.3),"",VLOOKUP(A1,H1:J7,3,1))
>
> Note: *any* score greater than 0.9 will return extraordinary opportunity.
>
> Biff
>
> "Derrick Robinson" <morale222@hotmail.com> wrote in message
> news:C2ume.4604$zb.3814@trndny06...
>>I created an advertising opportunity score sheet. When I arrive at the
>>total score I would like excel to display some words telling what the
>>number means in terms of advertising opportunity
>> Examples - If the total is any of the following the text should be
>> displayed below the score or beside the score.
>>
>> .90 - 1.0 = extraordinary opportunity
>> .80 - .89 = excellent opportunity
>> .70 - .79 = very good
>> .60 - .69 = good
>> .50 - .59 = average opportunity
>> .40 - .49 = poor
>> ,30 - .39 = very poor
>>
>> I hope I am making sense.
>> Thank you
>>
>> Derrick
>>
>
>