 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007IF, THEN HELP
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) >I have the following in Col A: > 18-35-DPL [quoted text clipped - 4 lines] > > Can someone help me with this? Thanks! No, it doesn't give me anything, only what I typed. I think I put in everything correctly. > Try this: > [quoted text clipped - 16 lines] >> >> Can someone help me with this? Thanks! The cell you entered the formula in is formatted as text. Change it to General, re-enter the formula. Bob Umlas Excel MVP > No, it doesn't give me anything, only what I typed. I think I put in > everything correctly. [quoted text clipped - 19 lines] >>> >>> Can someone help me with this? Thanks! 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) > No, it doesn't give me anything, only what I typed. I think I put in > everything correctly. [quoted text clipped - 19 lines] >>> >>> Can someone help me with this? Thanks! Thanks for the help. I had the cells formatted as text instead of general. Once I changed that, it worked fine. Thanks Again! > That suggests one of 2 problems: > [quoted text clipped - 41 lines] >>>> >>>> Can someone help me with this? Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.