Formula

[snap.lc]

Hello

Can anyone assist me

I want you show text in a cell that relates to a value from another cell

for example

If a value from 1 to 67 is displayed in cell A1 - i would like cell A2 to show a text

something like this ..... 67% in cell A1 Poor in Cell A2

I am using excel 97 any assistance will be appreciated.

Thanks

Les

 

[repairman615]

Hello,
Welcome to the Message Board!

Here is an example of the LOOKUP() function. I find the function when used in this fashion below is very handy.


A1 has the percentage

=LOOKUP(A1,{0.67,0.75,0.85,0.95},{"Poor","Low","Medium","High"})

 

[VoG]

Maybe like this

=LOOKUP(A1,{0,0.68,1},{"poor","middling","good"})

 

[Jonmo1]

Is there going to be more to it?
Like
1-67 = Poor
68-75 = Fair
76-85 = Good
86-95 = Very Good
96+ = Excellent

Something like that?

If so build yourself a table to show the relationship, then use a lookup formula.
Something like this

Hope it helps

Excel Workbook
	A	B	C	D	E
1	74%	Fair		1%	Poor
2				68%	Fair
3				76%	Good
4				86%	Very Good
5				96%	Excellent
Sheet2