show different text in cell based on range of #s in other cell

G

Guest

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"
Click to expand...

I am new to VBA (learn as I go) so keep it as simple as you can, please.
 
D

Dave Peterson

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"))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display diff text based numbers in another cell 1
If then statement based on time of day 3
Display CountA Formula and Text String in a cell 4
how to clear cell based on text in other column 1
predict text based on cell range? 1
If Statement? Update text in one cell based on another 4
Update Pivot Table Filters based on a Cell Value in Excel 2007 0
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2

Top