Home >Topics >word >Word commonly used function formulas

Word commonly used function formulas

Guanhui
GuanhuiOriginal
2020-05-25 16:58:2828345browse

Word commonly used function formulas

Commonly used function formulas in Word

You can also use functions in Word, and Word has provided you with 18 kinds of functions. The following are The content is the names, function introduction and usage methods 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, one result will be returned, and if the test is false, another result will be returned. 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 if the input value is 0, return 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 tutorial: "PHP Tutorial"

The above is the detailed content of Word commonly used function formulas. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn