Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Drop-down lists | Excel Worksheet Functions | |||
Conditional Lists | Excel Discussion (Misc queries) | |||
conditional lists | Excel Worksheet Functions | |||
Conditional Drop Down Lists | Excel Discussion (Misc queries) | |||
Conditional drop-down lists | Excel Worksheet Functions |