search
HomeTopicswordWord commonly used function formulas

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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Chat Commands and How to Use Them
1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools