Thread: Replace numbers to 1s and 0s for presence/absence
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
charles charles is offline
external usenet poster
  
Posts: 124
Default 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?
Reply With QuoteReply With Quote