Automatic text

T

Thor

Is it possible to make the sheet write pre-set comments to numbers which
follows specific parameters.

fx.
0-50
The value shows...
51-80
This above average value reveals...
81-100
Perfection

Thank you
 
R

Ron Coderre

Try this:

With
A1: (a numeric value)

Then
B1: =LOOKUP(A1,{0,51,81},{"The value shows...","This above average value
reveals...","Perfection"})

Or...slightly more robust:
B1: =IF(ISNUMBER(A1),LOOKUP(A1,{0,51,81},{"The value shows","This above
average value reveals..","Perfection"}),"")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
R

Ron Rosenfeld

Is it possible to make the sheet write pre-set comments to numbers which
follows specific parameters.

fx.
0-50
The value shows...
51-80
This above average value reveals...
81-100
Perfection

Thank you
Click to expand...

One way to do this is with custom formatting.

I'm not sure exactly what you want to display, but you can set several
conditions under Format/Cells/Number/Custom Type:

For example:

[<=50]"The value "0" shows blah";[<=80]"The value "0" is above average";0" This
value shows perfection"

all typed in the Type box

Obviously, you can alter the text before and after the displayed number to be
what you wish.


--ron
 
Top