What are the eight most commonly used functions in word?

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!