IF, THEN HELP

  • Thread starter Thread starter Betty Csehi
  • Start date Start date
B

Betty Csehi

I have the following in Col A:
18-35-DPL
RR-9-19

In Col B, I want a formula that returns "Yes" if the cell in Col A contains
DPL, and "No" if it does not.

Can someone help me with this? Thanks!
 
Try this:

=IF(COUNTIF(A1,"*dpl*"),"Yes","No")

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
No, it doesn't give me anything, only what I typed. I think I put in
everything correctly.
 
The cell you entered the formula in is formatted as text. Change it to
General, re-enter the formula.
Bob Umlas
Excel MVP
 
That suggests one of 2 problems:

1) Do you have Excel set for manual calculation?
From the Excel Main Menu:
<tools><options><calculation tab>
....Check: Automatic
....Click [OK]

2) Is the cell's numeric format set for Text?
<format><cells><number tab>
Category: (set this for one of the number formats: General, Number, etc)
....Click [OK]
Then...edit the cell...make no changes...press [enter]

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Thanks for the help. I had the cells formatted as text instead of general.
Once I changed that, it worked fine. Thanks Again!

Ron Coderre said:
That suggests one of 2 problems:

1) Do you have Excel set for manual calculation?
From the Excel Main Menu:
<tools><options><calculation tab>
...Check: Automatic
...Click [OK]

2) Is the cell's numeric format set for Text?
<format><cells><number tab>
Category: (set this for one of the number formats: General, Number, etc)
...Click [OK]
Then...edit the cell...make no changes...press [enter]

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


Betty Csehi said:
No, it doesn't give me anything, only what I typed. I think I put in
everything correctly.
Click to expand...
Click to expand...
 
Back
Top