Introduction to Excel Common functions (3)

15. IsError function

Function Name: ISERROR

Main function: To test whether the numeric value returned by a function is wrong. If there is an error, the function returns True, and returns false instead.

Use format: ISERROR (value)

Parameter Description: value represents the values or expressions that need to be tested.

Application Example: Input formula: =iserror (A35/B35), after confirmation, if B35 cell is empty or "0", then a35/b35 an error occurs, the preceding function returns true result, vice versa return false.

Special reminder: This function is usually associated with the IF function, if the above formula is modified to: =if (ISERROR (a35/b35), "", a35/b35), if the B35 is empty or "0", the corresponding cell is displayed as NULL, otherwise the result of the a35/b35 is displayed.

16, Left function

Function Name: Left

Main function: To intercept a specified number of characters, starting with the first character of a text string.

Use format: Left (text,num_chars)

Parameter Description: Text represents the string to truncate the character, and the num_chars represents the given number of intercepts.

Application example: Assuming that the "I like Tenkine" string is saved in cell A38, we enter the formula in the C38 cell: =left (a38,3), which displays the character "I like" after confirmation.

Special reminder: This function name of the English meaning of "left", that is, from the left to intercept, Excel many functions take its meaning in English.

17, Len function

Function Name: LEN

Main function: Count the number of characters in the text string.

Use format: LEN (text)

Parameter Description: Text represents the literal string to be counted.

Application example: Assuming that the "I am 28 years old" string is saved in cell A41, we enter the formula in cell C40: =len (A40), which shows the statistical result "6" after confirmation.

Special reminder: Len to be counted, regardless of the full-width character, or half-width character, each character enclosed counted as "1"; corresponding to a function--lenb, in the statistical time half-width Word characters "1", Full-width word characters "2".