Command

[Derrick Robinson]

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

[Chip Pearson]

Take a look at the VLOOKUP function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


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

[Biff]

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
>

[Derrick Robinson]

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