View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Asa_johannesen Asa_johannesen is offline
external usenet poster
 
Posts: 11
Default converting continuous data into binary data

Hi.

I was wondering is there is any way for me to convert a list of numbers into
another list of numbers giving me a return of either 1 or 0 depending on
whether the original number was above or below a certain limit. Say if my
numbers were from 0 to 9 and I decide to set the limit at 5 I would get a
list of 0s where the original number was below 5 and 1s where the original
was 5 or more.

Thanks