Widcards

Lewy2 · May 10th, 2002, 12:09 AM

I am trying to write a IF formula to look in a cell to find text that has a number which varies for the first character followed by mm then one to three words. ie "1mm PVC Colour" the Formula ihave tried is
IF(a1="*mm*",b1*b2,0) which returns 0 my reading of the rules is it should return the result of b1*b2

Colo · May 10th, 2002, 12:19 AM

Hi Lewy2,

In the formula "IF", we can not use the wildcard like *.
So, another way...

=IF(ISERR(FIND("mm",A1))=FALSE,B1*B2,0)

Lewy2 · May 10th, 2002, 12:26 AM

Thanks Colo, it works great

May 10th, 2002, 12:19 AM	#2
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Hi Lewy2, In the formula "IF", we can not use the wildcard like . So, another way... =IF(ISERR(FIND("mm",A1))=FALSE,B1B2,0) __________________ Regards, Masaru Kaji aka Colo - Ex Microsoft MVP Since 2004 -2009

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 12:09 AM	#1
Lewy2 New Member Join Date: Mar 2002 Location: Surfers Paradise Posts: 19	I am trying to write a IF formula to look in a cell to find text that has a number which varies for the first character followed by mm then one to three words. ie "1mm PVC Colour" the Formula ihave tried is IF(a1="mm",b1b2,0) which returns 0 my reading of the rules is it should return the result of b1b2

May 10th, 2002, 12:26 AM	#3
Lewy2 New Member Join Date: Mar 2002 Location: Surfers Paradise Posts: 19	Thanks Colo, it works great