View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR-BHS[_2_] JR-BHS[_2_] is offline
external usenet poster
 
Posts: 2
Default If/and functions

I have a number of values in column A ranging from 0-2.3. I'd like to create
a formula that will place a 1 in column B for those values greater than or
equal to 0.18, or a 0 for those values less than .18. Any help you all could
provide would be greatly appreciated!

JR