LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
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 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 K-rmen4U 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


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

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

About Us

"It's about Microsoft Excel"