View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sky Sky is offline
external usenet poster
 
Posts: 10
Default 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