View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
swheeler swheeler is offline
external usenet poster
 
Posts: 1
Default Display text based on a numeric range

I need to display text based on the number that is displayed in a cell. for
instance, if the number is between 1-3, I need to display "Low"; between 4-6,
I need to display "Medium"; and between 7-9 I need to display "high". How
can I set this up to work? thanks