Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 27th 07, 09:06 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
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

  #2   Report Post  
Old August 27th 07, 09:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default 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   Report Post  
Old August 27th 07, 09:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 11
Default 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   Report Post  
Old August 27th 07, 09:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default 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   Report Post  
Old August 27th 07, 09:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 3,268
Default 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   Report Post  
Old August 27th 07, 10:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 11
Default 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   Report Post  
Old August 27th 07, 10:12 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Selection of Non-Continuous Data [email protected] Excel Worksheet Functions 3 January 15th 07 08:10 PM
Formula for converting Binary to Hexadecimal Teraawete Tekena New Users to Excel 1 March 23rd 06 08:14 AM
Write Data in Excel with continuous reports K-rmen4U New Users to Excel 0 February 10th 06 02: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 08:09 PM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017