Home 
Search 
Today's Posts 
#1




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 
#2




converting continuous data into binary data
=N(A1=5)
"Asa_johannesen" wrote: 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 
#3




converting continuous data into binary data
Thanks for the swift reply
However, that only returns a #NAME? message in the cell (well assuming it's name in english, it's navn in danish). Am I doing something wrong? Ta "Toppers" skrev: =N(A1=5) "Asa_johannesen" wrote: 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 
#4




converting continuous data into binary data
try:
in B1: =(A1=5)*1 "Asa_johannesen" wrote: Thanks for the swift reply However, that only returns a #NAME? message in the cell (well assuming it's name in english, it's navn in danish). Am I doing something wrong? Ta "Toppers" skrev: =N(A1=5) "Asa_johannesen" wrote: 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 
#5




converting continuous data into binary data
=TAL(A1=5)
M.v.h. Peo Sjoblom "Asa_johannesen" wrote in message ... Thanks for the swift reply However, that only returns a #NAME? message in the cell (well assuming it's name in english, it's navn in danish). Am I doing something wrong? Ta "Toppers" skrev: =N(A1=5) "Asa_johannesen" wrote: 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 
#6




converting continuous data into binary data
Tak!
mvh Ása "Peo Sjoblom" skrev: =TAL(A1=5) M.v.h. Peo Sjoblom "Asa_johannesen" wrote in message ... Thanks for the swift reply However, that only returns a #NAME? message in the cell (well assuming it's name in english, it's navn in danish). Am I doing something wrong? Ta "Toppers" skrev: =N(A1=5) "Asa_johannesen" wrote: 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 
#7




converting continuous data into binary data
Thanks, that worked
"Toppers" skrev: try: in B1: =(A1=5)*1 "Asa_johannesen" wrote: Thanks for the swift reply However, that only returns a #NAME? message in the cell (well assuming it's name in english, it's navn in danish). Am I doing something wrong? Ta "Toppers" skrev: =N(A1=5) "Asa_johannesen" wrote: 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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Multiple Selection of NonContinuous Data  Excel Worksheet Functions  
Formula for converting Binary to Hexadecimal  New Users to Excel  
Write Data in Excel with continuous reports  New Users to Excel  
adjacent data count from a binary column  Excel Worksheet Functions  
3D Chart with Continuous Data in all three Axes  Charts and Charting in Excel 