If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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 
Ads 
#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 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Multiple Selection of NonContinuous Data  [email protected]  Excel Worksheet Functions  3  January 15th 07 07:10 PM 
Formula for converting Binary to Hexadecimal  Teraawete Tekena  New Users to Excel  1  March 23rd 06 07:14 AM 
Write Data in Excel with continuous reports  Krmen4U  New Users to Excel  0  February 10th 06 01:13 AM 
adjacent data count from a binary column  mike  Excel Worksheet Functions  1  July 15th 05 03:00 PM 
3D Chart with Continuous Data in all three Axes  Barb Reinhardt  Charts and Charting in Excel  3  January 10th 05 07:09 PM 