| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF command
TM
my apology, your formula provided is working fine. I didn't check the cell's reference. -- Thank You cheers, ======================== please click the Yes button if this help "Teethless mama" wrote: =COUNTIF(A1,"*complication*") "JRD" wrote: I want to use the IF command as follows: =IF(A1="*complication*", 1,0) so that if A1 contains "No complication" it would return the answer 1 However it is not working Does anyone know why? Thanks JD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| command button add another command | Excel Discussion (Misc queries) | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| Command | Excel Worksheet Functions | |||
| Dos command | New Users to Excel | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Hybrid Mode
