Bạn đang xem bài viết Functions And Formulas That You Can Use In A Word Document được cập nhật mới nhất trên website Hoisinhvienqnam.edu.vn. Hy vọng những thông tin mà chúng tôi đã chia sẻ là hữu ích với bạn. Nếu nội dung hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất.
You can use simple formulas in Microsoft Word, such as addition (+), subtraction (-), multiplication (*), or division (/). Also, you can calculate a power of (^):
See How to reference a cell of a Word table for more details.
All functions you can see in the Paste function drop-down list of the Formula dialog box:
ABS ()
Calculates the absolute value of the value inside the parentheses.
AVERAGE ()
Calculates the average of the elements identified inside the parentheses.
COUNT ()
Calculates the number of elements identified inside the parentheses.
DEFINED ()
Evaluates whether the argument inside parentheses is defined. Returns 1 if the argument has been defined and evaluates without error, 0 if the argument has not been defined or returns an error.
IF ()
Evaluates the first argument. Returns the second argument if the first argument is true; returns the third argument if the first argument is false.
INT ()
Rounds the value inside the parentheses down to the nearest integer.
MAX ()
Returns the maximum value of the items identified inside the parentheses.
MIN ()
Returns the minimum value of the items identified inside the parentheses.
MOD ()
Takes two arguments (must be numbers or evaluate to numbers). Returns the remainder after the second argument is divided by the first. If the remainder is 0 (zero), returns 0.0.
NOT
Evaluates whether the argument is true. Returns 0 if the argument is true, 1 if the argument is false. Mostly used inside an IF formula.
OR ()
Takes two arguments. If both are false, returns 0, else returns 1. Mostly used inside an IF formula.
PRODUCT ()
Calculates the product of items identified inside the parentheses.
ROUND ()
Rounds the first argument to the number of digits specified by the second argument. If the second argument is greater than zero ( 0), first argument is rounded down to the specified number of digits. If second argument is zero ( 0), first argument is rounded down to the nearest integer. If second argument is negative, first argument is rounded down to the left of the decimal.
SIGN ()
Takes one argument that must either be a number or evaluate to a number. Evaluates whether the item identified inside the parentheses if greater than, equal to, or less than zero ( 0). Returns 1 if greater than zero, 0 if zero, -1 if less than zero.
SUM ()
Calculates the sum of items identified inside the parentheses.
The arguments can be:
See also this tip in French: Fonctions et formules dans Word.
How To Use The Document Map In Microsoft Word
Once upon a time, Word’s Document Map had a poor reputation. That reputation was justified. Until Word 2002, it was very flaky. I’ve had Word 2000 crash while displaying the Document Map more times than I can remember.
But from Word 2002, it improved a lot, and in Word 2010 it has been re-vamped and moved to centre stage. The document map is very useful, so give it a go.
How to invoke Document MapFigure 1: The three parts to the Navigation Pane in Word 2010
To see the Document Map:
In all versions except Word 2007: Alt-V-D. (We lost the old keyboard shortcut in Word 2007, but it was reinstated for Word 2010!!)
You’ll see the Document Map on the left of your Word screen.
What does the Document Map do?Strictly speaking, it doesn’t do anything. It just sits there on the left of your screen. What it shows you, however, can be very useful. It shows an outline of your document. That is, it shows all the headings in your document. You get to choose whether to show just the highest-level headings, or lower-level headings as well.
How to get Document Map to display something usefulTo get Document Map to display useful headings, apply the built-in heading styles to the headings in your document.
There are many ways to apply the heading styles.
In Word 2003 and earlier versions, the easiest way is probably to use the Styles combobox on the toolbar. (And if you’re used to using that, in Word 2007 and Word 2010, you can reinstate the Styles combobox to the Quick Access Toolbar.)
From the Styles combo box, choose Heading 1 for your main headings, Heading 2 for sub-headings and Heading 3 for minor headings, and so on.
How to use the Document Map to move around your document quickly How to use the Document Map to see where you are in a documentIf you have a really big document, it’s sometimes easy to get “lost”. You can see a page of text, but it’s hard to know where you are in the document.
Document Map is a good way to solve this problem. As you move around your document, the Document Map will highlight the current heading.
For example, in Figure 1, I can see that the cursor is within the section with the heading “Balloons”. In Figure 2, I can see that the cursor is within the section “Sea transport”.
How to control the number of levels that Document Map displaysThere are two controls available:
How to change the format of the text in the Document Map
In Word 2007 and earlier versions, text in the Document Map is shown in style Document Map. Modify the Document Map style to suit your needs. I find that 10pt Tahoma works well. This feature was removed from Word 2010.
How to change the width of the Document MapHover over the vertical bar separating the Document Map from your text. Drag left or right to suit your needs. See Figure 3.
Figure 3: Hover over the vertical bar to the right of the Document Map and drag to change the width of the Document Map.
How to use the Document Map in Word 2010The Document Map has changed substantially in Word 2010 (Figure 4). It’s not even officially called the Document Map any more, but since it does not have a new name, it seems sensible to keep using the old one.
It now shares the new “Navigation Pane” with a panel for Find and one for Thumbnails. (Except they’re not called Find and Thumbnails any more either; but, like the Document Map they don’t have new names, so using the old names seems sensible.)
There good things about the changes:
Best of all: I can drag a heading in the Document Map, and the heading, and all the paragraphs of text “below” it, will move.
The old pre-Word 2007 keyboard shortcut of Alt-V-D has been reinstated. So I can open the new Document Map with the keyboard shortcut I’ve been using for a decade or more.
Word no longer guesses about what to show in the Document Map. It displays paragraphs based solely on each paragraph’s outline level.
But there are things I don’t like so much about the new Document Map:
It shows a lot less content than the old one. It’s pretty, but because the headings are in little buttons, each one takes up a lot more space. We lose 40% to 50% of the content compared with Word 2007 (the smaller your screen resolution, the bigger the hit).
To change the number of heading levels displayed in the Document Map requires one more mouse movement than the old version. One more mouse movement in this case is a change from 2 to 3, or a reduction in productivity of 50%.
There is some [NOTE: outdated link removed by Lene Fredborg 29-Dec-2016] some good material about the new Document Map at chúng tôi written during the beta testing of Office 2010.
There are several problems with Document Map:
Document Map doesn’t show headings that are in tables. I find this really annoying. It’s a known bug that has been inherited by the “new” Document Map of Word 2010. I guess it won’t get fixed any time soon.
Document Map doesn’t show headings that are in text boxes. Even the “new” Document Map of Word 2010 fails to show headings in a text box. Until Word 2007, text in a text box did not appear in the table of contents. So we weren’t likely to put a heading in a text box. Since that bug was fixed, we can put headings in a text box, and it’s the only straight-forward way to lay text over an image. So the failure of the new document map to show headings is particularly irritating.
In the Paragraph dialog, on the Line and Page Breaks tab, tick “Page Break Before”. Or, better, use the “Keep with Next” setting to keep the paragraph on the same page as the next paragraph. Or, better still, format your document using styles that have been modified with an appropriate “Keep with next” setting.
In Word 2007 and earlier versions, sometimes the Document Map decides to display tiny, unreadable type. It’s a known bug. The solution is to switch to Outline View and then back again. That is:
For the curious or the frustrated: How does Word decide what to display in Document Map? Word 2007 and earlier versions
More usefully, the Outline Level can be derived from the style you apply to your text. The built-in heading styles have their Outline Level fixed (Heading 1 has Outline Level 1, Heading 2 has Outline Level 2 and so on). If you create a custom style, you can modify it to have the Outline level you choose.
If your document has text with appropriate Outline Levels, Document Map will use those outline levels. If Word can’t find any text with appropriate Outline Levels, then, in Word 2007 and earlier versions, Word will guess. (In Word 2010, Word no longer guesses. Hooray!)
Turn off Document Map.
Create a new Word document.
Copy the following text into your document:
A small line of text The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.Another short line The quick brown fox jumps over the lazy dog. jumps over the lazy dog.Few words here The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.
Turn on Document Map.
You can see that Word has guessed that short, bold lines are headings and has changed the Outline Level of the paragraphs.
Since no-one ever wants Word to guess, make sure you apply appropriate styles (which have appropriate Outline Levels) to your text. Then you will be controlling what displays in Document Map.
Word 2010Word displays text in the Document Map based entirely on the Outline Level of the paragraph. It does not guess.
Acknowledgement Fellow MVP Klaus Linke worked out the problem with the missing heading numbering in Document Map.
How To Count Number Of Words In Excel Cell? (Using Formulas)
How to Count Total Number of Words in a Cell of Excel?
The steps to count the total number of words in a cell of Excel are listed as follows:
Step 1: Select the cell in the Excel sheet where you want the result to appear.
Step 2: For counting the number of words in cell A1, enter the formula shown in the following image.
To count the number of words in a range of cells, apply the equation that counts the words in a cell and implant it either inside the SUM or the SUMPRODUCT function.
The formula to count words of a particular range is “=LEN(TRIM(cell))- LEN(SUBSTITUTE(cell,” “,””))+1.”
Step 1: Select the range of data whose words you wish to count.
Step 2: Enter the formula in the cell where you want the result to display as shown in the succeeding image.
Step 4: Drag the fill handle to all cells to get the word count of each cell.
To count the number of times a specific word appears in a range of cells, we utilize a comparative methodology. We count the explicit words in a cell and consolidate it with the SUM or SUMPRODUCT function.
Step 1: Select the cell and enter the formula “=(LEN(cell)-LEN(SUBSTITUTE(cell,word,””)))/LEN(word)” as shown in the following image.
The result in cell A14 is 4.
The formula for counting the number of words in Excel is:
LEN(SUBSTITUTE(A2,” “,””))
Let us understand the working of this formula.
To begin with, we utilize the SUBSTITUTE function to evacuate and displace all spaces in the cell with a vacant content string (“). The LEN function restores the length of the string without spaces.
Popular Course in this category
Further, we utilize the TRIM function to remove extra spaces in a cell. A worksheet may contain a lot of imperceptible spaces. Such coincidental occurrence might be towards the start or end of the text (leading and trailing spaces). Since extra spaces return an incorrect word count, the TRIM function is used before computing the length of the string.
Characteristics of the Word Count FormulaThe features of the word count formula are listed as follows:
It is not an in-built formula of Excel and needs to be entered manually.
It is not case sensitive which implies that any type of alphabetical letters can be used.
It is essential to place the $ sign to fix the cell reference while copying the formula.
It works well if the cell, for which the formula is being used, is checked beforehand.
It requires the correct range to be specified at the time of usage.
Frequently Asked Questions #1 – How to count the number of times a single character appears in a cell?The formula to count the occurrence of a single character in a cell is stated as follows:
=LEN(cell_ref)-LEN(SUBSTITUTE(cell_ref,”a”,””))
The “cell_ref” stands for cell reference. The letter “a” stands for the character that the user wants to count.
#2 – How to count the number of times a single character appears in a range of cells?The formula to count the occurrence of a single character in a range of cells is stated as follows:
=SUM(LEN(range)-LEN(SUBSTITUTE(range,”a”,””)))
The “range” stands for the range of cells to which the formula is applied. The letter “a” stands for the character that the user wants to count.
#3 – How to count the number of times a specific word appears in a row or a column?The steps to count the number of times a particular word appears in a row or a column are listed as follows:
If the column is named “NamesColumn,” the cells in this column will use “NamesColumn” for reference.
Apply the formula “=COUNTIF(NamesColumn,”Jack”)” to count the number of times “Jack” appears in the “NamesColumn.”
Note: Every time a new name is added to a cell of “NamesColumn,” the result of the formula will automatically update.
Key Takeaways
The formula to count words of a particular range is “=LEN(TRIM(cell))-LEN(SUBSTITUTE(cell,” “,””))+1.”
The word count formula is combined with the SUM or SUMPRODUCT function to handle arrays.
The SUBSTITUTE function replaces all the spaces of the cell with a vacant content string (“).
The LEN function restores the length of the string without spaces.
The TRIM function removes the leading and trailing spaces found at the beginning or at the end of the text.
The number of words in a cell is equivalent to the number of spaces plus 1.
Recommended ArticlesThis has been a guide to Word Count in Excel. Here we discuss how to count the total number of words in a cell and a range of cells using Excel formulas (LEN, SUBSTITUTE, TRIM) along with practical examples and a downloadable Excel template. You may learn more about Excel from the following articles –
How To Use The Excel Sumif Function
SUMIF is in a group of eight functions in Excel that split logical criteria into two parts (range + criteria). As a result, the syntax used to construct criteria is different, and SUMIF requires a cell range for the range argument, you can’t use an array.
SUMIF only supports a single condition. If you need to apply multiple criteria, use the SUMIFS function. If you need to manipulate values that appear in the range argument (i.e. extract the year from dates to use in criteria) see the SUMPRODUCT and/or FILTER functions.
Videos
Basic usageIn the worksheet shown, there are three SUMIF examples. In the first example (G6), SUMIF is configured to sum values greater than 100. In the second example (G7), SUMIF returns the sum of values where the color is “red”. In the last example (G8), SUMIF is configured to sum values where the state is “CA” (California).
=
SUMIF
(
B6:B10,
"Jim"
,
D6:D10)
// Rep = Jim
=
SUMIF
(
C6:C10,
"ca"
,
D6:D10)
// State = CA
Notice the equals sign (=) is not required when constructing “is equal to” criteria. Also notice SUMIF is not case-sensitive. You can sum values where the Rep is Jim using “jim” or “Jim”.
Criteria in another cell Not equal toTo express "not equal to" criteria, use the "" operator surrounded by double quotes (""):
Again notice SUMIF is not case-sensitive.
Blank cellsSUMIF can calculate sums based on cells that are blank or not blank. In the example below, SUMIF is used to sum the amounts in column C depending on whether column D contains "x" or is empty:
=
SUMIF
(
D5:D9,
""
,
C5:C9)
// blank
The best way to use SUMIF with dates is to refer to a valid date in another cell, or use the DATE function. The example below shows both methods:
=
SUMIF
(
B5:B9,
"<"
&
DATE
(
2019
,
3
,
1
),
C5:C9)
WildcardsThe SUMIF function supports wildcards, as seen in the example below:
=
SUMIF
(
B5:B9,
"mi*"
,
C5:C9)
// begins with "mi"
=
SUMIF
(
B5:B9,
"*ota"
,
C5:C9)
// ends with "ota"
=
SUMIF
(
B5:B9,
"????"
,
C5:C9)
// contains 4 characters
See below for more SUMIF formula examples.
Notes
SUMIF only supports one condition. Use the SUMIFS function for multiple criteria.
When sum_range is omitted, the cells in range will be summed.
Cell references in criteria are not enclosed in quotes, i.e. "
The wildcard characters ? and * can be used in criteria. A question mark matches any one character and an asterisk matches any sequence of characters (zero or more).
To find a literal question mark or asterisk, use a tilde (~) in front question mark or asterisk (i.e. ~?, ~*).
SUMIFS requires a range, you can't substitute an array.
Cập nhật thông tin chi tiết về Functions And Formulas That You Can Use In A Word Document trên website Hoisinhvienqnam.edu.vn. Hy vọng nội dung bài viết sẽ đáp ứng được nhu cầu của bạn, chúng tôi sẽ thường xuyên cập nhật mới nội dung để bạn nhận được thông tin nhanh chóng và chính xác nhất. Chúc bạn một ngày tốt lành!