Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |