• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

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.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/32006/excel-find-function "

{ 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