If Function

[b166er]

HI MEMBERS,

I need help to use if function with wild card. i want to get the value of 40(5th character) out of 32/2540-25 if i used wild 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.

[Bob Phillips]

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"b166er" <[email protected]> wrote in
message news:[email protected]...
>
> HI MEMBERS,
>
> I need help to use if function with wild card. i want
> to get the value of 40(5th character) out of 32/2540-25 if i used wild
> 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.
>
>
> --
> b166er
> ------------------------------------------------------------------------
> b166er's Profile:
http://www.excelforum.com/member.php...o&userid=34912
> View this thread: http://www.excelforum.com/showthread...hreadid=546522
>

[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

"b166er" wrote:

>
> HI MEMBERS,
>
> I need help to use if function with wild card. i want
> to get the value of 40(5th character) out of 32/2540-25 if i used wild
> 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.
>
>
> --
> b166er
> ------------------------------------------------------------------------
> b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
> View this thread: http://www.excelforum.com/showthread...hreadid=546522
>
>

[Ragdyer]

If I understand your question:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"b166er" <[email protected]> wrote in
message news:[email protected]...
>
> HI MEMBERS,
>
> I need help to use if function with wild card. i want
> to get the value of 40(5th character) out of 32/2540-25 if i used wild
> 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.
>
>
> --
> b166er
> ------------------------------------------------------------------------
> b166er's Profile:
http://www.excelforum.com/member.php...o&userid=34912
> View this thread: http://www.excelforum.com/showthread...hreadid=546522
>