Conditional Formula w/Lists

[ncjelj]

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.

 

[Jacob Skaria]

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

 

[T. Valko]

You probably have unseen whitespace characters in the cell.

Try this...

=COUNTIF(C2,"*Daily*")