Solved

Finding text with two cells

Posted on 2013-10-25
3
156 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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone 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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 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