Alpha conditional statements

D

Dick W.

*east does not find Northeast in the following formula:-
=if(a1="*east",a1,"")
What am I doing wrong?
Office XP
Thanks, Dick W
 
P

Peo Sjoblom

That will throw an error if it doesn't find anything, you have to wrap it in
either ISNUMBER or ISERR/ISERROR


=IF(ISNUMBER(SEARCH("east",A1,1)),A1,"")


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ranking question 2
Questionnaire using Excel 3
Average using Sumproduct 4
Match and index returning N/A 6
If C2 = East AND D2 < 20,000.00 then multiply D2 by 8% 4
Establishing most common word in an Excel column 10
if function help 3
Help with VLOOKUP & MATCH formula 5

Top