Wild Characters in "IF" function

[jakar]

I've seen in this forum that someone already asked the question but there was no answer...
I'm also unable to use the wild character (*) in my IF function - I want the formula to return $51.44 and $25.31 amounts in column D if "EXON" chain is encountered in cells of column B. My statement looks like this: =IF(B4="EXXON*",C4,0) but it doesn't work...

Calumn A Column B Column C Column D
10/29/2005 HEINIE'S MARKET $12.28
10/30/2005 VAIL PASS SALES 0374 $198.00
10/29/2005 EINSTEIN BROS #1793 $7.54
10/27/2005 EXXONMOBIL75 $51.44 $51.44
10/27/2005 HEINIE'S MARKET $11.97
10/27/2005 EXXONMOBIL35 $25.31 $25.31

Any ideas????
Thanks,
jakar

[Anne Troy]

Try this:
=IF(left(B4,5)="EXXON",C4,0)
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"jakar" <[email protected]> wrote in
message news:[email protected]...
>
> I've seen in this forum that someone already asked the question but
> there was no answer...
> I'm also unable to use the wild character (*) in my IF function - I
> want the formula to return $51.44 and $25.31 amounts in column D if
> "EXON" chain is encountered in cells of column B. My statement looks
> like this: =IF(B4="EXXON*",C4,0) but it doesn't work...
>
> Calumn A Column B
> Column C Column D
> 10/29/2005 HEINIE'S MARKET $12.28
> 10/30/2005 VAIL PASS SALES 0374 $198.00
> 10/29/2005 EINSTEIN BROS #1793 $7.54
> 10/27/2005 EXXONMOBIL75 $51.44 $51.44
> 10/27/2005 HEINIE'S MARKET $11.97
> 10/27/2005 EXXONMOBIL35 $25.31 $25.31
>
> Any ideas????
> Thanks,
> jakar
>
>
> --
> jakar
> ------------------------------------------------------------------------
> jakar's Profile:
> http://www.excelforum.com/member.php...o&userid=28844
> View this thread: http://www.excelforum.com/showthread...hreadid=485929
>

[Dave Peterson]

=if(left(b4,5)="exxon",c4,0)

is one way.

jakar wrote:
>
> I've seen in this forum that someone already asked the question but
> there was no answer...
> I'm also unable to use the wild character (*) in my IF function - I
> want the formula to return $51.44 and $25.31 amounts in column D if
> "EXON" chain is encountered in cells of column B. My statement looks
> like this: =IF(B4="EXXON*",C4,0) but it doesn't work...
>
> Calumn A Column B
> Column C Column D
> 10/29/2005 HEINIE'S MARKET $12.28
> 10/30/2005 VAIL PASS SALES 0374 $198.00
> 10/29/2005 EINSTEIN BROS #1793 $7.54
> 10/27/2005 EXXONMOBIL75 $51.44 $51.44
> 10/27/2005 HEINIE'S MARKET $11.97
> 10/27/2005 EXXONMOBIL35 $25.31 $25.31
>
> Any ideas????
> Thanks,
> jakar
>
> --
> jakar
> ------------------------------------------------------------------------
> jakar's Profile: http://www.excelforum.com/member.php...o&userid=28844
> View this thread: http://www.excelforum.com/showthread...hreadid=485929

--

Dave Peterson

[jakar]

thank you very much... - it worked...
jakar