| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 Non-Continuous 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 | |||
Linear Mode
