View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ncjelj ncjelj is offline
external usenet poster
 
Posts: 1
Default Conditional Formula w/Lists

I'm trying to write a conditional formula that is reading the result of a
list function. I can't seem to get it to work for text - I'm using quotes
around the text - for example:
C2 C3
Daily =if(c2="Daily",1,0)

It's not working using this formula.
Any ideas??? HELP!
Thanks.