Excel Formula Application Encyclopedia

Excel Formula Application Encyclopedia

1. Abs function

Function Name: ABS

Main function: Find out the absolute value of the corresponding number.

Use format: ABS (number)

Parameter Description: number represents a value or a referenced cell that requires an absolute value.

Application Example: If you enter a formula in cell B2: =abs (A2), a positive number (such as 100) appears in B2 regardless of whether you enter a positive number (such as 100) or a negative number (such as -100) in the A2 cell.

Special reminder: If the number parameter is not a numeric value, but some characters (such as a, etc.), then the error value is returned in B2 "#VALUE! ”。

2, and function

Function Name: and

Main function: Returns the logical value: if all parameter values are logical true (TRUE), return the logical True (TRUE) and return the logical false (FALSE) instead.

Use format: and (Logical1,logical2, ...)

Parameter description: Logical1,logical2,logical3 ... : Represents the condition value or expression to be tested, up to 30.

Application example: In C5 cell input formula: =and (A5>=60,B5>=60), confirmed. If True is returned in C5, the value trunk in A5 and B5 is thrown 0, and if False, the values in A5 and B5 are at least one less than 60.

Special reminder: If the specified logical condition parameter contains a non logical value, the function returns the error value "#VALUE!" or "#NAME".

3. Average function

Function Name: AVERAGE

Main function: Calculate the arithmetic mean value of all parameters.

Use format: AVERAGE (Number1,number2,......)

Parameter description: Number1,number2,...... : A value or reference cell (range) that requires an average value or no more than 30 parameters.

Application Example: Enter the formula in cell B8: =average (b7:d7,f7:h7,7,8), after confirmation, you can find the B7 to D7 region, F7 to the H7 area of the value and the average of 7, 8.

Special reminder: If the reference range contains a "0" value cell, it is counted, and if the reference range contains white space or character cells, it is not counted.

4, COLUMN function

Function Name: COLUMN

Main function: Displays the column label value of the referenced cell.

Use format: COLUMN (Reference)

Parameter description: Reference is the referenced cell.

Application Example: Enter the formula in cell C11: =column (B11), which is displayed as 2 (that is, column B).

Special reminder: If you enter a formula in cell B11: =column (), it also shows 2, and a function--row (reference) that returns the label value of the row.