Q. I need to perform a calculation if specific text is found inside a cell in an Excel work sheet. It won’t always be in the same place. How would I do that?
A. FIND locates the starting position of text within the cell you’re examining with something like =FIND(“my text”,A1). It will return a #VALUE if it does not find the text. You can create an IF statement telling Excel what calculation to perform if it finds the text. To avoid the #VALUE error, wrap the function in an IFERROR with the value_if_error set to empty double quotes “”.
It will look something like this =IFERROR(IF(FIND(“Repair”,A1),B1*C1,””),””). Replace B1*C1 with your formula.