View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jason
 
Posts: n/a
Default number range returning a text value

Hi,

I would like to be able to return a specific text when a number is added to
a column. For example, if a number is inputted and it falls within the range
"1-5", then the text field "low" is returned. If however "6" is inputted, the
result would give the text "Medium", and if "10" is inputted, the returning
text field is "High"

Thanks for any help