【 Weak current College 】 Office, clerk, finance will (4)

31, TEXT functions
Function name: TEXT
Main feature: according to the specified number format to the appropriate number is converted to text.
Use the format: TEXT (value, format_text)
Parameter description: value represents the need to convert the numeric value or a referenced cell; the specified text form format_text is a digital format.
Application examples: If the B68 cell hold numerical 1280.45, we enter a formula in a cell C68: = TEXT (B68, "$ 0.00"), after confirmation is displayed as "$ 1280.45".
Remind: the format_text argument can "format cells" dialog box "digital" tab to determine the type.
32, TODAY function
Function name: TODAY
Main functions: to give the system date.
Use the format: TODAY ()
Parameter description: this function does not require parameters.
Example of application: enter a formula: = TODAY (), confirmation immediately after showing the system date and time. If the system date and time has changed, as long as you press the F9 function keys, you can make the change.
Special reminder: displayed in a date format, you can use the cell format to be reset (see annex).
33, VALUE function
Function name: VALUE
Main functions: one representative of the value of the text string is converted to a numeric type.
Use the format: VALUE (text)
Parameter description: text represents the need to convert text-string value.
Application examples: If B74 cell is LEFT as a function of the text string interception, we enter a formula in a cell C74: = VALUE (B74), after confirmation, you can convert them to numeric.
Remind: If a text type value is not after the conversion, use the function to handle these values, always returns an error.
34, VLOOKUP function
VLOOKUP function names:
Main features: the first column in the data table to find the specified value, and then returns a data table in the current row of the column of values.
Use the format: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
Description: the Lookup_value argument represents the you want to look up a value; representatives need Table_array in which to look for the cell range of data; a Col_index_num in table_array range wait returns a match value of the column ordinal (when a Col_index_num of 2 returns the table_array, 2 column, 3 column 3 of the return value of ... ); A Range_lookup is a logical value, if true or omitted, it returns the approximate matching values, that is, if an exact match is not found, the return value is less than lookup_value maximum value; if false, it returns the exact match, if not found, returns the # n/a error value.
Example of application: see Figure 7, we enter a formula in a cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the B65 cell type a student's name (e.g., t-48), D65 cell immediately shows the student's language.
Special reminder: Lookup_value see must in the first column of Table_array area; if you omit the Range_lookup argument, the first column of Table_array must be sorted; in this function wizard, the usage of the Range_lookup argument is wrong.
35, WEEKDAY function
Function name: WEEKDAY
Main functions: to specify the date of the corresponding week number.
Use the format: WEEKDAY (serial_number, return_type)
Parameter description: serial_number represents the specified date or references to cells containing date; return_type represents weeks of representation [when Sunday (Sunday) 1, Saturday to Saturday 7, this parameter is 1; when the Monday (Monday) to 1, Sunday (Sunday) to 7, this parameter is 2 (in this case meets Chinese habit); when the Monday (Monday) 0, Sunday (Sunday) is 6, the parameter is 3].
Example of application: enter a formula: = WEEKDAY (TODAY (), 2), confirmed that the system date in the days of the week.
Remind: If the date is specified, in the English state of double quotation marks, such as = WEEKDAY ("2003-12-18", 2).
1. Cell color effects in all forms, format-conditional formatting, select the "formula" conditions, the following formula, and then choose the "format" button, "patterns", select the desired color.