【 Weak current College 】 Office, clerk, finance will (3)---Power By 【 China power house network 】

Special reminder: each parameter in a formula, to use English in a comma-separated by ",".
21, Min function
Function name: MIN
Main features: find a group of numbers in the minimum value.
Use the format: MIN (number1, number2, ...)
Parameter number1, number2 Description: ... Representative to request a minimum value of a numeric value or reference cells (regional), arguments are not more than 30.
Example of application: enter a formula: = MIN (E44: J44, 7, 8, 9, 10), confirmed to display the E44-J44 unit and regional and numerical 7, 8, 9, 10 in the minimum value.
Remind: If a parameter in text or logical values are ignored.
22, MOD function
Function name: MOD
Main features: find out the remainder of dividing the two numbers.
Use the format: MOD (number, divisor)
Parameter description: number represents the dividend; divisor on behalf of the divisor.
Example of application: enter a formula: = MOD (13, 4), confirm that the results appear after the "1".
Remind: If divisor parameter is zero, the error value "# DIV/0!" ; MOD function can borrow function INT to represent: the above formula can be amended as follows: = 13-4 * INT (13/4).
23-MONTH function
Function name: MONTH
Main functions: to find the specified date or reference cell date month.
Use the format: MONTH (serial_number)
Parameter description: serial_number represents the specified date, or reference of the cell.
Example of application: enter a formula: = MONTH ("2003-12-18"), after confirmation, showing the 11.
Remind: If the date is given, included in double quotation marks; if the above formula is amended as follows: = YEAR ("2003-12-18") returns the value corresponding to the year "2003".
24 and NOW function
Function name: NOW
Main functions: to give the current system date and time.
Use the format: NOW ()
Parameter description: this function does not require parameters.
Example of application: enter a formula: = NOW(), confirmation immediately after showing the current 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: display date and time format, you can format the cell to reset.
25, OR function
Function name: OR
Main features: Returns the logical value only if all parameter values are logical "false (FALSE)," returns the function result logic "false (FALSE)"; otherwise, returns the logical "true (TRUE)".
Use the format: OR (logical1, logical2, ...)
Parameter description: Logical3 Logical1, Logical2, ... : Indicates that the question to test a value or expression in the condition, up to the 30.
Application examples: C62 cell input formula: = OR (A62 > = 60, B62 > = 60) and confirm. Returns true if C62, descriptions in the A62 and B62 in at least one is greater than or equal to 60, if you return false, the A62 and B62 in values are less than 60.
Remind: If you specify a logical condition argument contains non-logical value, the function returns the error value # VALUE! "" Or "# NAME".
26, the rank function
Function name: RANK
Main features: Returns a numeric value in a column value in relation to the other numerical rankings.
Use the format: RANK (Number, ref, order)
Parameter description: Number of values representing the needs of the sort; ref representative the sort numeric cells; order represents a sort parameter (if it is "0" or ignore, ranked in descending order, that is, the higher the value, the lower the rank result value; if it is not "0" value, ranked in ascending order, that is, the higher the value, the higher the ranking value;).
Application examples: If enter the formula in cell C2: = RANK (B2, $ B $ 2: $ B $ 31, 0), confirmed to draw small 1 students language results in class score ranking results.
Special reminder: in the above formula, we let the Number parameter takes a relative reference to the form, and letref parameters take the absolute reference form (a "$" symbol), this setting, select cell C2, move the mouse over the lower-right corner of the cell, into fine cross line (usually referred to as "the fill handle"), press and hold the left mouse button down and drag, you can quickly copy the formula to C column cells below, complete the rest of the languages of the results of the ranking statistics.
27, RIGHT function
Function name: RIGHT
Main feature: from a text string of the last character, the interception of a specified number of characters.
Use the format: RIGHT (text, num_chars)
Parameter description: text representative to stop a string of characters;Num_chars number given by the interception.
Application examples: assumes that the A65 cell saves the "I love New York," string, we enter the C65 cell formula: = RIGHT (A65, 3), confirmed that show "New York," characters.
Special reminder: Num_chars parameter must be greater than or equal to 0, if omitted, the default is 1; If num_chars is greater than the length of the text, the function returns the entire text.
28, the SUBTOTAL function
Function name: SUBTOTAL
Main functions: to return a list or database of subtotals.
Use the format: SUBTOTAL (function_num ref1, ref2, ...)
Parameter description: Function_num 1 to 11 (includes hidden values) or 101 to 111 (ignores hidden values) number, is used to specify what functions in the list for subtotal calculation (as in Figure 6); ref1, ref2, ... Representative to subtotal regional or reference, do not exceed 100.
Example of application: as shown in Figure 7, in B64 and C64 enter the formula in the cell: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63) and 61 lines hidden, acknowledgment, which appear as 62 (including hidden row), which appear as 61, not including the hidden rows.

Remind: If you take the AutoFilter, regardless of the type parameter selection function_num, the SUBTOTAL function ignores any are not included in the filter results in a row; the SUBTOTAL function for data columns or vertical zone, does not apply to data rows or horizontal area.
29, function name: SUM
Main features: calculate all values and parameters.
Use the format: SUM (Number1, Number2 ... ）
Parameter Number1, Number2 Description: ... Representatives need to calculate values, can be a specific value, reference cell (regional), logical values, and so on.
Example of application: as shown in Figure 7, in D64 cell formula: = SUM (D2: D63), confirmed to find the language of the total score.
Remind: If the parameter is an array or reference, only numbers are counted. An array or reference in the empty cells, logical values, text, or error values are ignored; if the above formula is amended as follows: = SUM (LARGE (D2: D63, {1, 2, 3, 4, 5})), you can find the 5 scores &.
30, SUMIF function
Function name: SUMIF
Main feature: meet the specified conditions of cell values and in the region.
Use the format: SUMIF (Range, Criteria, Sum_Range)
Parameter description: Range represent conditions determine the range of cells; Criteria for a specified condition expression; Sum_Range representative need to calculate the value of the cell area.
Example of application: as shown in Figure 7, in D64 cell formula: = SUMIF (C2: C63, "male", D2: D63), confirmed to find the "male" in the language of the health and performance.
Remind: If the above formula is amended as follows: = SUMIF (C2: C63, "female", D2: D63), you can find the "female" in the language of health; and the "male" and "female" as a text type, you need to put in the English state of double quotes ("male", "female").