Wild Characters in "IF" function

J

jakar

I've seen in this forum that someone already asked the question bu
there was no answer...
I'm also unable to use the wild character (*) in my IF function -
want the formula to return $51.44 and $25.31 amounts in column D i
"EXON" chain is encountered in cells of column B. My statement look
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,
jaka
 
D

Dave Peterson

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

is one way.
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
Click to expand...
 
Top