Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show different text in cell based on range of #s in other cell
I am trying to show a different text string in a cell based on a range of
numbers in another cell. C25 can display a range of numbers from 0 thru 150. I need cell A26 to display text if the numbers fall within a certain range: # displayed in cell (C25) text displayed in (A26) 0-9 "Use Good ADM/CRM 10-15 "Notify Dispatch/Manager" 16-20 "Manager Approval Req." 20 "CANCEL MISSION" I am new to VBA (learn as I go) so keep it as simple as you can, please. -- skyknight |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show different text in cell based on range of #s in other cell
How about a formula:
=IF(c25<10,"Use Good ADM/CRM",IF(c25<16,"Notify Dispatch/Manager", IF(c25<21,"Manager Approval Req.","CANCEL MISSION"))) Or if C25 can be empty: =if(c25="","",IF(c25<10,"Use Good ADM/CRM", IF(c25<16,"Notify Dispatch/Manager", IF(c25<21,"Manager Approval Req.","CANCEL MISSION")))) sky wrote: I am trying to show a different text string in a cell based on a range of numbers in another cell. C25 can display a range of numbers from 0 thru 150. I need cell A26 to display text if the numbers fall within a certain range: # displayed in cell (C25) text displayed in (A26) 0-9 "Use Good ADM/CRM 10-15 "Notify Dispatch/Manager" 16-20 "Manager Approval Req." 20 "CANCEL MISSION" I am new to VBA (learn as I go) so keep it as simple as you can, please. -- skyknight -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
formula for named cell/range based on cell values | Excel Programming | |||
Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
force text in a cell based on value of cell in a range | Excel Programming |