if function

[johnkelly08]

hi, can anybody help me with the if function, is it possible to use the if function but only using part of the text rather than the whole text from the source cell, something like =if(a1 contains the text "concealed","15mm","10mm").  Any suggestions. 

[#2 · Accepted solution]

@johnkelly08 

=IF(ISNUMBER(SEARCH("concealed",A1)),"15mm","10mm")

This formula works in my spreadsheet. 

[#3]

thank you much appreciated. Kindest Regards John