| 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 | |||
Linear Mode
