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!

在之前的文章《实用Word技巧分享:详解怎么更改图片颜色和形状》中,我们了解了更改图片颜色和图片形状的方法。而今天我们来聊一聊word表格,讲解美化表格--自定义表格样式的方法,快来看看吧!

在之前的文章《实用Word技巧分享:聊聊你没用过的“行号”功能》中,我们了解了Word中你肯定没用过的"行号”功能。今天继续实用Word技巧分享,看看Excel表格怎么借用Word进行分栏打印,快来收藏使用吧!

在之前的文章《实用Word技巧分享:设置页码的终极方法!》中,我们学习了Word页码的设置方法。而今天我们来一起聊聊Word文本间距设置的几个技巧,快来收藏使用吧!

在之前的文章《实用Word技巧分享:隐藏图片,提升文档浏览和编辑效率!》中,我们学习了隐藏图片的技巧,可提升文档浏览和编辑效率。下面本篇文章再给大家分享一个实用Word技巧,看看怎么让页面自动滚动,快来收藏使用吧!

在之前的文章《实用Word技巧分享:表格自定义样式,美化表格!》中,我们了解了自定义表格样式的方法。而今天我们来聊一聊word脚注和尾注,介绍一下脚注和尾注的设置使用方法,快来看看吧!

在之前的文章《实用Word技巧分享:怎么跨文档快速复制样式》中,我们了解了在文档间快速复制样式的方法。今天我们聊聊Word快捷键,聊聊【F4】键快速统一图片大小,快来看看吧!

在之前的文章《实用Word技巧分享:如何一键删除所有数字》中,我们学习了Word中一键删除所有数字的方法。而今天我们来聊聊Word表格中如何自动添加编号,简单却很实用!

在之前的文章《实用Word技巧分享:图、表如何自动编号?》中,我们了解了Word排版-让图、表自动编号的方法。而今天聊聊Word精确控制页面“行数”和“字符个数”的方法,快来看看吧!


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

SublimeText3 Linux new version
SublimeText3 Linux latest version

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

WebStorm Mac version
Useful JavaScript development tools

SublimeText3 English version
Recommended: Win version, supports code prompts!
