Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace numbers to 1s and 0s for presence/absence
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? |
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 |