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
|