Thread: Automatic text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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