word The eight most commonly used functions are: 1. AVERAGE function; 2. COUNT function; 3. MAX function; 4. MIN function; 5. ROUND function; 6. SUM function; 7. PRODUCT function; 8. DEFINED function.
The operating environment of this article: Windows7 system, Microsoft Office word2010, Dell G3 computer.
What are the eight most commonly used functions in word? Of course there are far more than 8.
You can use functions in Word, and Word has provided you with 18 functions. The following content is the name, function introduction and usage of these functions.
Function name: ABS
Function function: Return the absolute value of the input value. For example, function =ABS(-3) will return 3.
Function name: AND
Function function: Allows you to perform compound "AND" logic tests. For example, the function =AND(1=1,2 2=4) will return 1 because both logical tests in it are true.
Function name: AVERAGE
Function function: Calculate the arithmetic average of the input values. For example, the function =AVERAGE(1,2,3,4) will return 2.5.
Function name: COUNT
Function function: Count input values. For example, the function =COUNT(1,2,3,4,5,6) will return 6.
Function name: DEFINED
Function function: Determine whether the formula can be calculated. Returns 1 if the formula can be calculated, 0 if it cannot. For example, the function =DEFINED(1/0) will return 0 because no number can be divided by zero.
Function name: FALSE
Function function: Return the logical value 0 for false. For example, function =FALSE will return 0.
Function name: IF
Function function: perform a logical test. If the test is true, a result will be returned, and if the test is false, Return another result. For example, the function =IF(2 2=4,1,0) will return the value 1 because 2 2 is indeed equal to 4.
Function name: INT
Function function: Return the integer part of the value. For example, function =INT(3.5) will return 3.
Function name: MAX
Function function: Return the maximum input value. For example, function =MAX(1,2,3,4) will return 4.
Function name: MIN
Function function: Return the minimum input value. For example, function =MIN(1,2,3,4) will return 1.
Function name: MOD
Function function: Return the modulus (or remainder) remaining in the division operation. For example, the function =MOD(3,2) will return 1 because the remainder after dividing 3 by 2 is 1.
Function name: NOT
Function function: Allows you to perform compound "not" logic tests. For example, the function =NOT(1=1,2 2=4) will return 0. Because the results of both logical tests are true.
Function name: OR
Function function: Allows you to perform compound "OR" logic tests. For example, the function =OR(1>1,2 2=4) will return 1 because the result of the 2nd logical test is true.
Function name: PRODUCT
Function function: Multiply the parameters in the function. For example, function =PRODUCT(2,3,4) will return 24.
Function name: ROUND
Function function: Round the input value to the specified decimal precision. For example, the function =ROUND(123.456,2) will return 123.46.
Function name: SIGN
Function function: If the input value is a negative value, return -1, if the input value is a positive value, return 1, or 0 if the input value is 0. For example, the function =SIGN(-3) will return -1.
Function name: SUM
Function function: Sum input values. For example, function =SUM(2,2) returns 4.
Function name: TRUE
Function function: Returns a true logical value of 1. For example, function =TRUE will return 1.
Recommended study: "Word Tutorial"
The above is the detailed content of What are the eight most commonly used functions in word?. For more information, please follow other related articles on the PHP Chinese website!