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
IF(a1="*mm*",b1*b2,0) which returns 0 my reading of the rules is it should return the result of b1*b2