Excel FIND function — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Excel FIND function

by on
in Excel Training,Office Technology

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.

{ 1 comments‒ read them below or add one }

XLCalibre January 8, 2013 at 4:47 pm

A good tip! FIND is also really useful for manipulating text if you combine it with LEFT, RIGHT or MID. Here’s a walkthrough of each of those functions and an example of how they can be combined: http://xlcalibre.com/xl-formula-focus-left-right-mid-find-an-introduction-to-excel-text-functions

Reply

Leave a Comment