Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic links from onwe worksheet to another, depending on text | Excel Discussion (Misc queries) | |||
Inserting automatic text in Excel | Excel Worksheet Functions | |||
How can I get automatic row height for merged cells with text wra. | Excel Worksheet Functions | |||
Automatic colors for text | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |