Widcards

[Lewy2]

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]

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]

Thanks Colo, it works great