Conditional Formula w/Lists

  • Thread starter Thread starter ncjelj
  • Start date Start date
N

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.
 
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
 
You probably have unseen whitespace characters in the cell.

Try this...

=COUNTIF(C2,"*Daily*")
 
Back
Top