SOLVED

if function

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3163881%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3Eif%20function%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3163881%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3Ehi%2C%20can%20anybody%20help%20me%20with%20the%20if%20function%2C%20is%20it%20possible%20to%20use%20the%20if%20function%20but%20only%20using%20part%20of%20the%20text%20rather%20than%20the%20whole%20text%20from%20the%20source%20cell%2C%20something%20like%20%3Dif(a1%20contains%20the%20text%20%22concealed%22%2C%2215mm%22%2C%2210mm%22).%26nbsp%3B%20Any%20suggestions.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3163881%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3163881%22%20slang%3D%22en-US%22%3Eif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3163881%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%20can%20anybody%20help%20me%20with%20the%20if%20function%2C%20is%20it%20possible%20to%20use%20the%20if%20function%20but%20only%20using%20part%20of%20the%20text%20rather%20than%20the%20whole%20text%20from%20the%20source%20cell%2C%20something%20like%20%3Dif(a1%20contains%20the%20text%20%22concealed%22%2C%2215mm%22%2C%2210mm%22).%26nbsp%3B%20Any%20suggestions.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3163881%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@johnkelly08 

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

This formula works in my spreadsheet. 

thank you much appreciated. Kindest Regards John