| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
