Solved

Finding text with two cells

Posted on 2013-10-25
3
155 Views
Last Modified: 2013-10-25
I want to look at two cells and check for information.  In the A column I want to determine if the cell contains "***" which will be included with other text.  In addition I want to look at another cell to determine if the amount is over 32.
Here is my formula so far and it doesn't work.
=IF(AND(ISNUMBER(SEARCH("***",A5)))*E5>32,"Yes","No")
No matter what A5 contains (1, 2, 3 or no "*") the reply is "Yes."

Thanks in advance...
Marvin
0
Comment
Question by:mabarnes11
3 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39600325
The asterisks are wildcards, in order to override that you need to use tildes...

eg

=IF(AND(ISNUMBER(SEARCH("~*~*~*",A5)))*E5>32,"Yes","No")
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 39600336
Try FIND instead of SEARCH - FIND doesn't recognise wildcards so it treats the asterisks as you want.

You also need to tidy up the way you have used AND because it isn't treating E5>32 as a separate condition

Try this version

=IF(AND(ISNUMBER(FIND("***",A5)),E5>32),"Yes","No")

regards, barry
0
 

Author Closing Comment

by:mabarnes11
ID: 39600368
Thanks....
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question