If Function

B

b166er

HI MEMBERS,

I need help to use if function with wild card. i wan
to get the value of 40(5th character) out of 32/2540-25 if i used wil
card(?/*) with logical test eg

A1=32/??40* it shows invalid argument.

32/2540-25 is our cost job number and 40 character is for loacation.

32/2520-25 is our cost job number and 20 character is for loacation.
how can i use wild card with if logical function
 
B

Bob Phillips

=IF(ISNUMBER(FIND("40",A1)),"Found","Not found")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
K

kassie

=MID(A1,5,2) will give you 40, if 32/2540-25 is the data in A1. That is,
assuming that your numbers will always have this format
 
R

Ragdyer

If I understand your question:

=IF(MID(A1,6,2)="40","perform operation","don't perform")
 

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

wild card with if logical function 2
if function with multiple criteria 4
problem 2
IF FUNCTION, ADD MULTIPLE NUMBERS 2
Editing an "IF" function across a worksheet/excel file 2
very complex IF function if not an alternative function of crossselection 0
wild card with if logical function 7
Count If Function 10

Top