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.

Conditional Formula w/Lists
 

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.

Conditional Formula w/Lists
 

You probably have unseen whitespace characters in the cell.

Try this...

=COUNTIF(C2,"*Daily*")

--
Biff
Microsoft Excel MVP


"ncjelj" wrote in message
...
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.