Automatic text
 

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

Automatic text
 

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


"Thor" wrote:

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

Automatic text
 

On Sun, 12 Nov 2006 05:45:01 -0800, Thor <Thor @discussions.microsoft.com
wrote:

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

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