Check for any space or other characters such as 'Daily ' in cell C2. If
there are spaces TRIM() will help.

=IF(TRIM(C2)="DAILY",1,0)



If this post helps click Yes
---------------
Jacob Skaria


"ncjelj" wrote:

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.