Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
3, application of function in this case in order to achieve automatic data extraction, application of the following Excel function. (1) IF function: According to the results of testing the logic expression, return the corresponding value. Allow nested IF function. syntax form: IF (logical_test, value_if_true, value_if_false) (2) CONCATENATE: will the merger of a number of text to a text item. the form of syntax: CONCATENATE (text1, text2 ... ...) (3) MID: the text string from the start position is specified, the specified length of characters to return . the form of syntax: MID (text, start_num, num_chars) (4) TODAY: computer system to return to the current date. the form of syntax: TODAY () (5) DATEDIF: Calculation of the two the number of days between the date, the number of months or years. form syntax: DATEDIF (start_date, end_date, unit) (6) VALUE: the number will represent the string of text to digital. the form of syntax: VALUE (text) (7) RIGHT: According to the number of characters specified in the text string to return to the last one or more characters. the form of syntax: RIGHT (text, num_chars) (8) INT: return to it after a few round-off integer value. Grammatical form: INT (number) 4, formula writing and explain (to the staff Andy as an example) Description: In order to avoid too many nested formula, here limited to the identity card number of 15. If you understand the formula, it can carry out simple modifications can be applied to the identity card numbers of 18, 15,18 or even applicable to the case of the two co-exist. (1) based on gender identity card numbers for = IF (VALUE (RIGHT (E4, 3)) / 2 = INT (VALUE (RIGHT (E4, 3) ) / 2), "Female", "M") formula to explain: a. RIGHT (E4, 3) used to derive the representation of identity card numbers of other figures, the actual obtained for on behalf of the string figures b. VALUE (RIGHT (E4, 3) is used to step from the representative of the string is converted to digital c. VALUE ( RIGHT (E4, 3)) / 2 = INT (VALUE (RIGHT (E4, 3)) / 2 used to determine the identity card number is odd or even number, of course, you can also use Mod function to make judgments. d. = IF (VALUE (RIGHT (E4, 3)) / 2 = INT (VALUE (RIGHT (E4, 3)) / 2), "Female", "M") and to determine if the above formula that this number is even, the show that "women", otherwise, this number is odd, then return to the "M". |
