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
实用Word技巧分享:表格自定义样式,美化表格!实用Word技巧分享:表格自定义样式,美化表格!Jul 20, 2022 am 10:25 AM

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

Word与Excel联动:表格借用Word进行分栏打印!Word与Excel联动:表格借用Word进行分栏打印!May 07, 2022 am 10:28 AM

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

实用Word技巧分享:设置字符间距、行距和段落间距实用Word技巧分享:设置字符间距、行距和段落间距Apr 26, 2022 am 10:25 AM

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

实用Word技巧分享:使页面自动滚动实用Word技巧分享:使页面自动滚动May 02, 2022 am 10:00 AM

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

实用Word技巧分享:脚注和尾注的设置、转换和删除实用Word技巧分享:脚注和尾注的设置、转换和删除Jul 21, 2022 am 10:29 AM

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

实用Word技巧分享:【F4】键快速统一图片大小实用Word技巧分享:【F4】键快速统一图片大小Jun 07, 2022 am 10:27 AM

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

实用Word技巧分享:表格中如何自动添加编号实用Word技巧分享:表格中如何自动添加编号Apr 22, 2022 am 09:44 AM

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

实用Word技巧分享:怎么精控页面的“行数”和“字符个数”实用Word技巧分享:怎么精控页面的“行数”和“字符个数”Jun 01, 2022 am 11:04 AM

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

See all articles

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)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

SecLists

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

WebStorm Mac version

Useful JavaScript development tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!