| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace numbers to 1s and 0s for presence/absence
Create a helper column in column B, for example. Assuming your data is in
column A, enter the following formula in B1 = IF(A1,1,0) drag the formula down column B as far as necessary. When you're satisfied the result in column B is correct, delete column A. Tyro "Charles" wrote in message news:FA93245B-4B45-47CF-897E-4E5AC4DBC7FC@microsoftom... I have a data set with percent values ranging from 0 to 1. I want to replace all numbers greater than 0 to 1 in order to convert my data set to presence/absence. How do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replace numbers to 1s and 0s for presence/absence
Whoops!!! Major error!
When you're satisfied the results in column B are correct, copy column B and paste/special/values into column A and delete column B Tyro "Tyro" wrote in message et... Create a helper column in column B, for example. Assuming your data is in column A, enter the following formula in B1 = IF(A1,1,0) drag the formula down column B as far as necessary. When you're satisfied the result in column B is correct, delete column A. Tyro "Charles" wrote in message news:FA93245B-4B45-47CF-897E-4E5AC4DBC7FC@microsoftom... I have a data set with percent values ranging from 0 to 1. I want to replace all numbers greater than 0 to 1 in order to convert my data set to presence/absence. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Employee Absence Schedule for 2007? | Excel Discussion (Misc queries) | |||
| Detect Presence Formula | Excel Worksheet Functions | |||
| please help me mark their presence. | Excel Worksheet Functions | |||
| count their presence | Excel Worksheet Functions | |||
| how do I do a day to day holiday and absence chart | Setting up and Configuration of Excel | |||
![Tyro[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
