The EXCEL Find function returns value question 10

find is used to find other text strings.

within text) and returns the starting position number of find text, starting with the first character of within text. You can also use search to find a text string in other text strings, but, unlike search, find is case-sensitive and doesn't allow wildcards.

Grammar. find(find_text,within_text,start_num)

Find text is the text you want to find.

within text is the text that contains the text you want to find.

start num specifies the character to start the lookup. The first character in within text is the character numbered 1. If start num is omitted, it is assumed to be 1.

Prompt. Use start num to skip a specified number of characters. For example, if you want to find the number of the first "y" in the description part of the text string, you can set start num to 8 so that the serial number part of the text is not looked.

find will start with the 8th character and find text at the next character, so the return number always returns the character number from the beginning of within text, and if start num is greater than 1, the skipped character is also counted.

Illustrate. If the find text is empty text (""), find matches the first character in the search string (i.e., the character numbered start num or 1).

Wildcards cannot be included in the find text.

If there is no find text in within text, find and findb return the wrong value value!.

If start num is not greater than 0, find and findb return the error value value!.

If start num is greater than the length of within text, find and findb return the error value value!.

Material copying tool: excel2007

1. Open Excel2007 and click on the following figure to return the ranking of the teacher who taught Chinese or mathematics through the function.

2. First, use the find function to determine whether the data in column A contains language or mathematics.

3. If the find function is included, it will return the number of words or numbers in the text string.

4. If the subject does not contain Chinese or mathematics, the find function will return value! Error value.

5. The isnumber function is a logical judgment function, judging whether the parameter is a numerical value, if it is true, if it is not false, the two logical values are added, the logical value can be converted into 0 and 1 to participate in the operation, and the plus sign represents that the relationship between the two logical values is to satisfy one, that is, the relationship of or.

6. Finally, the outermost if function is like this, if the condition is met, it will return, rank, otherwise the third parameter will be returned.

First of all, the find function returns a number, e.g. find("gun",b2), and the value returned by this function should be "10", i.e. the "gun" position is the tenth in this text... Reflect on your formula is equivalent to: if(10, "bolt", "ball machine"), if is a judgment function, this "10" does not have any judgment anything, so the if function defaults, no matter what your value is, it returns "bolt" (i.e. select the first option "bolt", not the second option "ball machine").

The normal formula would be if(iserror(find("guns",b2,1))=false,"bolt,"dome"),iserror() function is the judgmentThe value in its parentheses is not problematicIf there is a problem with the find function (i.e., the word "gun" is not found), the find function will be confused, and the word "gun" will not be found, so the find function will become a "problematic" function.

The function of the iserror function will only make two judgments for any function in its parentheses, one "false", that is, this guy in my parentheses has a problem; "True", this dude in my parentheses is normal.

So, the formula I just wrote: if(iserror(find("guns",b2,1))=false,"bolt", "ball machine"), which translates as if (if the find function is not normal, return "gun ball", otherwise return "ball machine").

If the find function is found, it gives the starting position of the found character, which is a numeric value, not a t f value, so your return formula can't be set like this, I guess you want to find whether it contains "gun" in b2, if so, it will show "bolt", otherwise it will show "ball machine".

You can add an iserror function and change the formula to =if(iserror(find("guns",b2)),"Dome machine","Bolt machine")。

This is because the find function you use is related to the fact that if you can find the "gun", then it will return the location of the base. If it cannot be found, an error message is returned.

The formula needs to be modified as follows:

if(iserror(find("guns",b2)),"Spherical","Gun type")

The find function returns the location when it is found, and returns an error value when it cannot be found, which cannot be regarded as an untrue condition.

if(isnumber(find("guns",b2)),"Bolt machine","Dome machine")

Because the return value that can't be found is an error, if(iserror(find(.)."guns",b2)),"Dome machine","Bolt machine")

=if(isnumber(find("guns",b2)),"Bolt machine","Dome machine")

or =if(count(find(.)"guns",b2)),"Bolt machine","Dome machine")

or =if(iserror((find(.)"guns",b2)),"Dome machine","Bolt machine")