|
Wild Characters in "IF" function
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 |
Wild Characters in "IF" function
Try this:
=IF(left(B4,5)="EXXON",C4,0) ************ Anne Troy VBA Project Manager www.OfficeArticles.com "jakar" wrote in message ... 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 |
Wild Characters in "IF" function
=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 |
Wild Characters in "IF" function
thank you very much... - it worked... jakar -- jakar ------------------------------------------------------------------------ jakar's Profile: http://www.excelforum.com/member.php...o&userid=28844 View this thread: http://www.excelforum.com/showthread...hreadid=485929 |
| All times are GMT +1. The time now is 07:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com