You can't paste a formula into Word. Formulas in Excel

Also articles about working with tables in Word:

  • How to select tables in Word?
  • Designing tables in Word
  • How to pin a table in Word?
  • How to create an invisible table in Word?

Formulas in a Word table allow you to perform only some mathematical and logical operations, and are not at all comparable in functionality to formulas in Excel. Formulas in a Word table are a type of field codes and are applicable only within one table. To use data from other tables in a document, it is possible to substitute values ​​for which a bookmark has been created. In addition, calculation results are updated only when the document is opened or when updated manually. To do this, select the formula and press the “F9” key.

Calculations in tables in Word are performed immediately after creating the formula. To obtain reliable data when using empty cells in calculations, empty cells should be filled with zeros. When composing formulas in Word, positional arguments are used to simplify some entries. LEFT, RIGHT, ABOVE, BELOW, but their use is only possible in the following functions AVERAGE, COUNT, MAX, MIN, PRODUCT, SUM. Note that when using positional arguments, the values ​​in the header row are not taken into account.

Each cell in the table has its own serial number, and there are two options for recording the position of a cell in a Word table. For example, you can write a cell reference in the format RnCn, where Rn corresponds to the nth row and Cn corresponds to the nth column.

The second method of writing the addresses of table cells is more familiar, since similar addressing is used in Excel. In this option, the letter corresponds to the column and the number to the row of the cell.

There are not many functions available for calculations in a Word table.

Now let's try to create a formula in a Word table and, for example, calculate the sum of numbers in two cells located in different tables. Before you start creating a formula, you need to place the cursor in the table cell in which the result of the calculation should ultimately be located. After that, go to the “Layout” tab of the “Working with Tables” tab and select “Formula” from the menu. Next, in the list of functions, select the required function and indicate the required table cells. We have created a bookmark for the value in the second table, and to substitute this value into our formula, just select the bookmark name in the list of bookmarks. If desired, you can also set the number format.

Optionally, you can display the cell code to see the formula itself. This is done by highlighting the calculation result and selecting the appropriate menu item after clicking the right mouse button.

Learn to work in Word for dummies

Hello, friends! After reading today's Cheat Sheet, you will be convinced that calculations in WORD tables are a fairly simple matter. We will learn how to perform all arithmetic operations with digital data from Word tables, find the average, and calculate percentages. We won’t deal with higher mathematics (I promise): and we’ll send those who need integrals, derivatives, or (forgive me, lords) extrema of functions straight to Excel.

But before we proceed directly to the calculations, let's remember how it is customary to set cell addresses in tables. In Fig. Figure 1 shows a table with numbered rows and labeled columns.

(pictures are clickable)

To make it clear, I quote the addresses of the numbers in it:

  • A5 - 12;
  • B2 - 34;
  • C3 - 47;
  • D6 - 61.

Moreover, it is not at all necessary to put letter designations for columns or number rows directly in the table itself: such addressing is implied by default. Now you can proceed directly to the calculations. And we will start with the most common case.

How to add numbers of a column or row in a Word table

We perform all mathematical operations with numbers in Word tables from the panel "Working with tables", which opens by left-clicking in the table field or on the move marker (cross in the upper left). Next, go to the tab "Layout", chapter "Data", button "formula"(see Fig. 2).

In order to add the numbers of one line, you need to place the cursor in its last cell intended for the sum and click in the drop-down dialog box "Formula" by button "OK". So it's simple? In this case, yes. The fact is that by default the text editor offers to calculate exactly the sum, and the location of the cursor in the last cell will explain to the smart program that all the numbers in this line need to be added (Fig. 3).

Of course, if you need to add not all the numbers in a row, but only from several columns, then this problem can be solved. Then simply place the cursor in the column after the numbers to be summed. Please, friends, pay attention to the entry in the top line of the window "Formula": = SUM(LEFT)- this inscription just means: the sum of the numbers to the left of the cursor. In the same way, the program can calculate for us the sum of the numbers to the right of the cursor - = SUM(RIGHT).

I would like to draw your attention, dear readers, that despite his fairly developed intellect, Word does not tolerate emptiness, that is, he perceives an unfilled cell as an error. This means that all empty cells will need to be filled with zeros.

In a similar way, you can sum the numbers in a series by placing the cursor in its lower cell. In this case, the entry in the line "formula" the window of the same name will look like this: = SUM(ABOVE)(see Fig. 3), which means the sum of the numbers in the cells located above. Accordingly, if necessary, add numbers from the cells below the cursor, enter: = SUM(BELOW).

Words - LEFT(left), RIGHT(on right), ABOVE(above), BELOW(sub) - called positional arguments. They are convenient to use for operations in rows and columns, and Word does not take into account the numbers in the heading line.

So, friends, we have discussed with you the simplest and most frequently used version of calculations in Word tables, when the program runs “automatically”. In all other cases, you will have to select a formula and enter the initial data for each pair of cells. Now I will explain to you how this is done.

How to multiply, divide or subtract numbers in a WORD table

To perform these actions, the easiest way is to use arithmetic operators: * - multiplication; / - division; - - subtraction. Here are examples of entries that can be entered in a line "formula":

  • addition - =A1+B2;
  • multiplication - =A5*B5;
  • division - =B4/B1;
  • subtraction - =A6-B6.

Please note that every formula begins with an equal sign (=). And then, without any spaces, enter the cell addresses and arithmetic signs.

For multiplication, the program provides another option - PRODUCT. This is a multiplication function, just like SUM- addition. In this case, the cell addresses must be entered in parentheses separated by a semicolon (see Fig. 4). If we are talking about finding the product of a column or row, then you can not list all the cells, but specify them using an interval separated by a colon, for example: = PRODUCT(A1:A8).

And now, friends, a little about the sad. You must have already realized that tables in Word are suitable only for simple calculations; the range of possible operations is small. Moreover, in the above examples of arithmetic operations, changing one or both arguments (values ​​in cells) will not automatically change the result. To get a new value, you will need to select the old one and press the key F9 or by right-clicking on the highlighted number and selecting the line in the pop-up window "update field".

Among other mathematical functions for calculations in tables in Word, the following are available:

  • arithmetic average in the range: = AVERAGE();
  • Determining the maximum and minimum values ​​in the specified cells: = MAX/MIN();
  • remainder of the division: =MOD();
  • selecting the integer part of a number: = INT();
  • rounding to the indicated digit: = ROUND().

We will not discuss the remaining functions - statistical and logical - within the scope of this article. What we have left of what was promised is interest and the arithmetic average. So let's take care of them.

How to calculate the arithmetic mean in a WORD table and calculate percentages

  1. To calculate the arithmetic mean in a row or column, place the cursor in their last cell and open the window "Formula" ("Working with tables"- tab "Layout"- chapter "Data"- button "Formula"). In the top line of the window, enter the required formula: = AVERAGE(A1:A7) and in the last (eighth) cell of the first column we get the result (see Fig. 5).
  1. To calculate percentages in a window "Formula" we will have to write: =/100* . Let's say we want to take 3% of 300. Enter: =A3/100*3 or even simpler: =A3*0.03. The result, of course, is 9. But I deliberately took prime numbers, the result of the operation with which is easy to check in my head. You, friends, having grasped the principle of this procedure, can now operate with any values.

To repeat and consolidate the material covered, I suggest watching a short video.

I hope that after watching the video, calculations in WORD tables no longer pose any difficulties for you.

Goodbye friends. Your guide to WORD 2016 copywriter GALANT.

Haven't you read these articles yet? In vain... This is also about tables:

  • Columns and rows of a WORD 2016 table
  • All about borders and frames of WORD 2016 tables

In the Word section

Few people know that the familiar Microsoft Office Word can not only create beautifully designed documents. He is also excellent at making calculations, for example in tables.

Yes, most people don’t realize that without leaving the Word text editor you can add, subtract, divide and multiply the contents of Word table cells.

Try filling the column with numbers, place the cursor in the free cell below, and then on the “Working with Tables - Layout” tab (we are considering the Office 2007/2010 version, in Office 2003 you need to use the “Table” menu) select the “Formula” command.

Microsoft Word will automatically determine that the numbers you are about to process are higher, and since most tasks for calculating data in tables come down to addition, the program itself substituted the autosum formula =SUM(ABOVE)

If the data were to the left, then the formula would be slightly different: =SUM(LEFT). You can check - Microsoft Office Word copes with this routine perfectly.

But what should I do if I want to not just add, but, for example, subtract or multiply numbers?

Everything is just as simple. What do you think will appear in the cell if you write the formula =2*2? That's right, the result will be printed. I hope you still remember what it is equal to?

It must be said that the Microsoft Office Word editor operates a cell addressing system similar to that adopted in Microsoft Office Excel - that is, the columns are named by letters of the Latin alphabet, and the rows are named by numbers. Thus, the table structure looks like this:

Accordingly, you can use cell references in formulas:

The function argument can also be a range of cells:

This example adds the values ​​of four cells in the first row in a row

To multiply, you can use the “*” symbol or a special function:

Multiplying a number by a cell =(A1)*3 Multiplying two adjacent cells =PRODUCT(A1:A2) Multiplying two non-adjacent cells =(B1*B3)
or
=PRODUCT(B1)*(B3)

Division is done using a regular slash:

Dividing a cell by a number =(C2)/3 Dividing one cell by another =(C2)/(A1)

Unfortunately, we must admit that the value calculated by the formula in the cell is calculated at the moment the formula is inserted. If the values ​​of the numbers in the cells referenced by the formula change, the result of the formula calculation is not recalculated.

In the same way, you cannot copy a formula - in fact, only the result of the calculation is stored in the cell, and this can be copied.

What to do - this is not a spreadsheet, but just a text editor. We do more complex calculations in Microsoft Office Excel

You may also be interested in information on the following keywords, which are commonly searched for on my website
presentations for word 2007 free download
download office 2007 for free without registration
power point 2007 video
office 2007 download
Google calendar "office 2007"
microsoft office 2007 free download

MicrosoftWordWordchips

Microsoft, Word, chips

We have already written quite a lot about the capabilities of the advanced text editor MS Word, but it is simply impossible to list them all. The program, which is primarily focused on working with text, is by no means limited to just this.

Lesson: How to make a diagram in Word

Sometimes working with documents involves not only textual, but also numerical content. In addition to graphs (diagrams) and tables, you can also add mathematical formulas to Word. Thanks to this feature of the program, you can perform the necessary calculations quite quickly, in a convenient and visual form. It is how to write a formula in Word 2007 - 2016 that will be discussed below.

Lesson: How to make a table in Word

Why did we indicate the program version starting from 2007, and not from 2003? The fact is that built-in tools for working with formulas in Word appeared precisely in the 2007 version; before that, the program used special add-ons, which, moreover, were not yet integrated into the product. However, in Microsoft Word 2003 you can also create and work with formulas. We will tell you how to do this in the second half of our article.

Creating formulas

To enter a formula in Word, you can use Unicode characters, mathematical autocorrect elements, replacing text with symbols. A regular formula entered into the program can be automatically converted into a professionally formatted formula.

1. To add a formula to a Word document, go to the tab "Insert" and expand the button menu “Equations”(in program versions 2007 - 2010 this item is called "Formula"), located in the group “Symbols”.

2. Select an item “Insert new equation”.

3. Enter the required parameters and values ​​manually, or select symbols and structures in the control panel (tab "Constructor").

4. In addition to manually entering formulas, you can also use those contained in the program’s arsenal.

5. In addition, a large selection of equations and formulas from the Microsoft Office website is available in the menu item "The equation" - “More equations from Office.com”.

Add frequently used formulas or those that have been formatted in advance

If you often refer to specific formulas when working with documents, it will be useful to add them to the list of frequently used ones.

1. Select the formula you want to add to the list.

2. Click the button "The equation" (“Formulas”), located in the group "Service"(tab "Constructor") and in the menu that appears, select “Save the selected fragment to the collection of equations (formulas)”.

3. In the dialog box that appears, enter a name for the formula you want to add to the list.

4. In paragraph "Collection" select “Equations” (“Formulas”).

5. If necessary, set other parameters and click "OK".

6. The formula you saved will appear in the Word quick access list, which opens immediately after clicking the button "The equation" ("Formula") in Group "Service".

Adding math formulas and structures for general use

To add a mathematical formula or structure in Word, follow these steps:

1. Click on the button "The equation" ("Formula"), which is in the tab "Insert"(group “Symbols”) and select “Insert new equation (formula)”.

2. In the tab that appears "Constructor" in Group “Structures” select the type of structure (integral, radical, etc.) you need to add, and then click on the structure symbol.

3. If your chosen structure contains placeholders, click on them and enter the required numbers (symbols).

Advice: To change an added formula or structure in Word, simply click on it with the mouse and enter the required numerical values ​​or symbols.

Add a formula to a table cell

Sometimes you need to add a formula directly to a table cell. This is done in the same way as with any other place in the document (described above). However, in some cases it is required that not the formula itself, but its result be displayed in a table cell. How to do this - read below.

1. Select an empty table cell in which you want to place the result of the formula.

2. In the section that appears “Working with tables” open the tab "Layout" and click on the button "Formula" located in the group "Data".

3. Enter the required data in the dialog box that appears.

Note: If necessary, you can select a number format, insert a function or bookmark.

4. Click "OK".

Adding a formula in Word 2003

As mentioned in the first half of the article, the 2003 version of Microsoft's text editor does not have built-in tools for creating and working with formulas. For these purposes, the program uses special add-ons - Microsoft Equation and Math Type. So, to add a formula to Word 2003, do the following:

1. Open a tab "Insert" and select "An object".

2. In the dialog box that appears in front of you, select Microsoft Equation 3.0 and press "OK".

3. A small window will appear in front of you "Formula" from which you can select signs and use them to create formulas of any complexity.

4. To exit the formula mode, simply left-click on an empty space on the sheet.

That's all, because now you know how to write formulas in Word 2003, 2007, 2010-2016, you know how to change and supplement them. We wish you only positive results in your work and training.

We are glad that we were able to help you solve the problem.

Ask your question in the comments, describing the essence of the problem in detail. Our specialists will try to answer as quickly as possible.

Did this article help you?

Hello, dear readers. Not many people know that calculations in Word exist, are available to everyone and work great. And this is so, believe me. Each of you can learn this. The main thing is to carefully read this article to the end, and then practice a little.

Of course, the computing capabilities of Word are not nearly comparable to Excel formulas, but the tasks facing these two programs are different. However, when you need to calculate something in a Word table, we can do it. And then also build a diagram. Didn't expect this from Word? I think no. So let's quickly figure it out.

How to do calculations in Word

Let's look at an example right away. Let us have a table with monthly sales of some employees. And we want to calculate, for example, the final data.

Yes, it would be more convenient to do this in Excel, but this table is part of a certain package of documents, a portfolio, if you like. Here's what we have:

We see that we have columns for filling in the totals. How should we count them? Not manually, right? Let's summarize Ivan Alekseev's sales by month. To do this, we perform the following sequence:

  1. Select a still empty cell, where we will have the sum
  2. On the ribbon click Layout - Data - Formula. The insert formula window opens
  3. We write down the formula: =SUM(LEFT). This will mean that you need to sum all the numeric values ​​to the left of this cell. That is, all sales by month.
  4. Click OK and get the result. Great, this is what I needed! The same manipulations can be done with the remaining resulting cells.

So what kind of formula did we write down? It is both similar and not similar to formulas in Excel. Let's break it down into parts:

  • "=" sign, as in Excel, signals that there will now be a formula
  • SUM is a summation function that will return the sum of the values ​​specified in the argument
  • LEFT– a function argument indicating that all numeric data located to the left of the given one should be summed. This entry is due to the fact that in Word there is no explicit addressing of table cells. There is addressing as such, I will describe it below, but it is not indicated anywhere on the screen.

Before we get into the list of available functions, let's clarify how else you can specify cell references in arguments. Although, of course, instead of links, you can simply specify values. You will get this kind of calculator in Word.

Cell references in Word formulas

Below I have given you a table of possible calls to Word cells:

Recording a request Decoding
LEFT All cells to the left of the formula
RIGHT All cells to the right of the formula
ABOVE All cells above the formula
BELOW All cells under the formula
LEFT;RIGHT All cells left and right
ABOVE;BELLOW All cells above and below
LEFT;ABOVE All cells on the left and top
RIGHT;ABOVE All cells to the right and top
LEFT;BELLOW All cells on the left and below
RIGHT;BELLOW All cells on the right and bottom
Cn Entire column. For example, C1 will access the first column
Rn The whole line. R1 refers to the first row
RnCn The cell at the intersection of the specified row and column. For example, R3C2 is the cell in the third row and second column
R Formula line
C Column with formula
RnCn:RnCn Range between cells separated by colon
Bookmarkname RnCn Cell in a table with bookmarks
Bookmarkname RnCn:RnCn Range in a table with tabs
Links A1 The type of links is similar to Excel, where rows are numbered with numbers and columns with letters. That is, B3 will point to the cell in the third row of the second column

Everything is simple in these parameters, I think you won’t get confused. And if you get confused, ask questions in the comments and we’ll figure it out together.

Now let's move on to the features available in this tool. They are also very similar to functions in Excel, but there are significantly fewer of them.

Calculation functions in Word

Above in the text we have already looked at the SUM function, and now I will describe to you all the functions available in Word.

Function Description Example Result
ABS Returns the modulus of a number =ABS(-21) 21
INT Drops the decimal part of a number =INT(3,548) 3
ROUND Rounds a number according to the laws of mathematics. The arguments indicate the number and number of decimal places for rounding =ROUND(32,548, 1)
=ROUND(32.548, -1)
32,5
30
COUNT Counts the number of elements specified in the argument =CONT(LEFT) 10
AVERAGE Calculates the average of the elements in the argument =AVERAGE(3;1) 2
SUM Sum of specified elements =SUM(1;2;3) 6
PRODUCT Product of arguments. =PRODUCT(2,2,3) 12
MOD Remainder of integer division. The first parameter specifies the dividend, and the second parameter specifies the divisor. =MOD(8;3) 2
MIN Determines the minimum value from the given ones =MIN(3,1,80) 1
MAX Determines the maximum value from the given ones =MAX(3,1,80) 80
SIGN Determines the sign of the specified number. If positive, returns “1”, negative – “-1”, zero – “0” =SIGN(15) 1
TRUE Returns logical TRUE. In Word it's "1" =TRUE 1
FALSE Returns a logical FALSE. In Word it's "0" =FALSE 0
NOT Logical inversion. Converts TRUTH to FALSE and FALSE to TRUTH =NOT(FALSE) 1
AND Returns TRUE when all its elements are true, otherwise FALSE =AND(TRUE;TRUE)
=AND(TRUE;FALSE)
1
0
OR Returns TRUE when at least one of its arguments is TRUE, otherwise FALSE =OR(5>3;2>8)
=OR(58)
1
0
IF Tests the condition in the first argument. If it is executed, it returns the value of the second argument. If not fulfilled - third =IF(2>3;1;-1)
=IF(2", "0.1; F3*0.05;0). The formula will check if the manager's sales share is greater than 0.1 (10%) - it will return 5% of his average sales. If not, it will return 0. For the first line we got 313.33, this is the correct result, you can check it manually

Using the Word editor, we create and process a huge number of documents. They often include all sorts of technical information, calculations and formulas. Accordingly, we must learn how to edit them and add them to the text of the document. After all, simple keyboard input is not enough in such a situation. Let's see how to insert formulas into Word, and what tools the popular editor offers us for this. Using this guide, you can independently add the necessary mathematical and other formulas and expressions to the document!

Introduction

In different versions of the word editor, formulas were added to the document text using various tools.

note. In the previous material, we configured it in all versions of the editor.

If we remember the old versions - 2000 and 2003, then the following tools were used there:

  • Math Type
  • Microsoft Equation 3.0

The latter, by the way, is still available.

Please note that if you are working in a new version of the editor with a document that was created in earlier versions of Word, you will need the appropriate add-in to edit formulas.

Or you need to convert the document to Word 2007 or 2010 format. But in this case, you will be able to insert new formulas, but not work with existing ones.

note. Converting documents does not require any special skills. We have already explained.

Working with formulas

If we are talking about simple formulas in Word, then you can use standard functionality to enter them. We can type numbers and symbols in lower and upper case from the keyboard without resorting to the use of special tools. A striking example where this can be used is entering chemical formulas.

Superscript. Press the key combination "CTRL + =" (control and equals). This will enable superscript input mode. Type the required characters, and finally press CTRL+= again. The same result can be obtained if you select the already typed text and press the combination of these keys.

Subscript. The process is similar here. Only the hotkeys are different. To activate subscript input mode, press "CTRL+Shift+= ".

These modes correspond to control buttons in the "Home" ribbon.

Formula editor in word 2010

Now let's try to solve a more complex problem. It's time to work with more complex formulas.

The built-in formula editor in Word will help us with this work. To launch it, go to the "Insert" ribbon and click the "Formula" button.

The same result will be achieved if you press the key combination Alt+= .

After this, a block for entering formulas will appear on the screen. And in the menu area, all the necessary tools will be available.

Now you can enter any, even the most complex formulas.

Changing formulas

To change a formula in the Word editor, just left-click on it. It will become editable and you can make the necessary changes.

As we already mentioned, if the formula was created in an earlier version of the program, in order to edit it you will need the add-in that was used to create it.

Inserting ready-made formulas

Word comes with a fairly large set of ready-made mathematical formulas. You can use them.

To insert, go to the "Insert" ribbon, and next to the "Formula" button, click on the arrow.

A drop-down menu will open showing all available formulas. To insert the desired one, just click on it with the mouse pointer. After that, all you have to do is substitute the required values.

Video for the article:

Conclusion

Now you can insert mathematical formulas and expressions into Word documents. Use this in your work.

In the previous material we looked at...

For our users, we told.

With us you will learn how to remove .

Why look for information on other sites if everything is collected here?

Quite often, many of us have had to deal with the need to draw up some documents in the Word text editor. And if typing and formatting text usually does not cause difficulties, then the need to enter formulas in the text seems to be an impossible task for some. Although, in reality, inserting and typing a formula in Word does not require any special skills and is a fairly simple task. For example, consider a set of formulas in different versions of Microsoft Word.

A set of formulas in Microsoft Word (using Word 2003 as an example)

First, let’s open a new Word document and enter some text to illustrate the example:

Suppose we need to enter a complex formula between these two paragraphs. To do this, you need to place the cursor in the place where we will insert the formula. Then, in the “Insert” menu, select “Object” and in the window that opens, select the “Microsoft Equation 3.0” object.

After you have selected the required object and clicked “OK”, the Microsoft Word formula editor will open in front of you. In this case, all panels will be replaced with other panels of the formula editor:

Now you can start directly entering your formula into the insert field, using formula elements (fractions, wildcards, and more). To exit the formula editing mode, just click on the empty space anywhere on the worksheet. If you need to edit the formula again, you need to double-click on the formula and it will open again in the formula editor.

Please note that in the above example, the formula elements are like miniature copies of the necessary elements with a symbol for the places where any values ​​will be entered.

As shown above, clicking this icon will insert a Square Root element along with a field where you can enter some values ​​or a new element (like a fraction or something else).

After some manipulation, we get a complex formula that contains fraction signs, square roots, exponentiation of numbers and other mathematical calculations.

The formula editing mode is actually very easy to manage and use. Using the Microsoft Equation 3.0 tool, you can create an unlimited number of formulas of any complexity. In addition, the formula can be copied, centered, and resized. And don’t be afraid to experiment with different elements, because if you wish, you can simply remove them.

A set of formulas in Microsoft Word 2007 (Microsoft Office 2007 package)

To set formulas in all subsequent versions of Word, the same editor “Microsoft Equation 3.0” is used. The principle of operation in this editor is the same as described above. The only difference is the launch of this formula editor. To do this, in the document that opens, select the “Insert” menu and in the “Text” section select the “Object” item, as shown in the figure:

Then in the window that opens, select “Microsoft Equation 3.0” and click “OK”. Next, in the formula editor, you can create various formulas in the same way as described above.

A set of formulas in Microsoft Word 2010 (Microsoft Office 2010 package)

The new version of the well-known package also does not have any fundamental differences in its work, therefore, to work with the formula editor “Microsoft Equation 3.0”, you also need to select the “Insert” menu in the document that opens and select the “Object” item in the “Text” section, as shown in drawing.

Calculations and logical comparisons can be performed using formulas. Team Formula is in the section Working with tables on the tab Layout in Group Data.

In Word, formulas update automatically when you open a document that contains them. Formula results can also be updated manually. See section for more information.

Note: Formulas contained in Word and Outlook tables are a type of field code. For more information about field codes, see the See Also section.

In this article

Inserting a formula into a table cell

    In chapter Working with tables on the tab Layout in Group Data click the button Formula.

    Using the dialog box Formula create a formula. You can enter a formula in the field Formula, select the number format in the field Number format, and also insert functions and bookmarks using lists Insert function And Insert bookmark.

Updating Calculation Results

In Word, the result of a formula is calculated when it is inserted and also when the document containing it is opened. In Outlook, the result of a formula is calculated only when you paste it, and the recipient of the message will not be able to change it.

In addition, manual updating of the following items is supported:

    results of individual formulas;

    the results of all formulas in a separate table;

    all field codes in the document, including formulas.

Updating individual formula results

    Select the formulas that need to be updated. To select multiple formulas, hold down the CTRL key.

    Do one of the following:

    • Right-click the formula and select Command Update field.

      Press F9.

Update the results of all formulas in a table

    Select the table containing the results of the formulas you want to update and press F9.

Update all formulas in a document

Important: As a result of this procedure, not only the formulas will be updated, but all field codes in the document.

    Press CTRL+A.

    Press F9.

Examples: Adding numbers in a table using positional arguments

Positional arguments (LEFT, RIGHT, ABOVE, BELOW) can be used for the following functions:

As an example, consider the procedure for adding numbers using the SUM function and positional arguments.

Important: To avoid an error when finding a sum in a table using positional arguments, enter a zero (0) in the empty cells included in the calculation.

    Select the table cell in which the result should appear. If the cell is not empty, delete its contents.

    In chapter Working with tables on the tab Layout in Group Data click the button Formula.

    In the dialog box Formula Do one of the following:

    Click OK.

Available features

Note: Formulas that use positional arguments (such as LEFT) do not take into account the values ​​in the header row.

You can use the following functions in formulas inside Word and Outlook tables.

Action

Return value

Determines the absolute value of a number in parentheses

Determines whether all arguments inside parentheses are true.

AND(SUM(LEFT)<10;SUM(ABOVE)>=5)

1 if the sum of the values ​​to the left of the formula (in the same row) is less than 10 And the sum of the values ​​above the formula (in the same column, excluding header cells) is greater than or equal to 5; otherwise - 0.

Finds the arithmetic mean of the elements specified in parentheses.

The arithmetic mean of all values ​​to the right of the formula cell (in the same row).

Determines the number of elements specified in parentheses.

The number of values ​​to the left of the formula cell (in the same row).

Sets whether the argument is defined inside the parentheses. Returns 1 if the argument is defined and evaluates without errors, or 0 if the argument is not defined or returns an error.

DEFINED(gross_income)

1, if the element "gross_income" is defined and calculated without errors; otherwise - 0.

Has no arguments. Always returns 0.

Evaluates the first argument. If the first argument is true, returns the second argument; if false - third.

Note: All three arguments must be specified.

IF(SUM(LEFT)>=10;10;0)

10 if the sum of the values ​​to the left of the formula is greater than or equal to 10; otherwise - 0.

Rounds the value in parentheses to the nearest integer (smaller).

Returns the largest value among the elements specified in parentheses.

The largest of the values ​​in the cells above the formula (excluding header row cells).

Returns the smallest value among the elements specified in parentheses.

The smallest of the values ​​found in the cells above the formula (excluding header row cells).

Has two arguments (numbers or expressions whose results are numbers). Returns the remainder when the first argument is divided by the second. If the remainder is zero (0), returns 0.0.

Has one argument. Determines the truth of the argument. If the argument is true, returns 0; if false - 1. Mainly used in the IF function.

Has two arguments. If at least one of them is true, returns 1. If both arguments are false, returns 0. Mainly used in IF function.

Calculates the product of the elements specified in parentheses.

The product of all the values ​​in the cells to the left of the formula.

Has two arguments (the first argument must be a number or an expression that results in a number, the second must be an integer or an expression that results in an integer). Rounds the first argument to the number of decimal places specified by the second argument. If the second argument is greater than zero (0), the first argument is rounded down to the specified number of decimal places. If the second argument is zero (0), the first argument is rounded down to the nearest integer. If the second argument is less than zero, the first argument is rounded to the left of the decimal point (down).

ROUND(123,456; 2)

ROUND(123,456; 0)

ROUND(123,456, -2)

Has one argument, which must be a number or an expression that results in a number. Compares the element specified in parentheses with zero (0). If this element is greater than zero, returns 1; if equal to zero - 0; if less than zero - -1.

Calculates the sum of the elements specified in parentheses.

The sum of the values ​​in the cells to the right of the formula.

Has one argument. Determines the truth of the argument. Returns 1 if the argument is true, 0 if false. Mainly used in the IF function.

Using bookmarks and cell references in a formula

You can insert a reference to a cell for which a bookmark has been created into a formula, using the name of the bookmark. For example, if a cell that contains a number or an expression that results in a number has a bookmark named gross income, formula =ROUND( gross income,0) will round the value of this cell down to the nearest whole number.

Note: Cells containing formulas are not included in calculations that use references. If the cell is part of a link, it is ignored.

RnCn format links

You can use the RnCn format to record a reference to a row, column, or table cell in a formula. Here Rn corresponds to the nth row, and Cn to the nth column. For example, reference R1C2 points to the cell in the first row and second column. The table below contains examples of writing links in this format.

A1 size links

You can use A1 format to record a reference to a cell, set, or range of cells. Here the letter corresponds to the column and the number to the row of the cell. The first column of the table is designated by the letter "A", and the first row by the number "1". The table below contains examples of writing links in this format.

Word is a recognized leader among text editors. However, some specific features of Word are not used every day and raise questions. Scientific and technical documents often contain mathematical formulas, the writing of which seems difficult without additional knowledge about using this tool in Word. There are several ways to insert formulas into a document.

Video on inserting formulas in Word

The simplest ways to insert formulas in MS-Word

The simplest option can be used if the task is only to use lower or upper case. In the main menu of Word, in the “Font” section, there are tools that allow you not only to change the typeface, style or point, but also to select a superscript or subscript version of the character. The buttons are designated as follows: X 2 and X 2. This feature will especially appeal to those who are faced with the problem of how to write chemical formulas and equations. The demand for such a function was heard by the developers, who assigned hotkeys for converting to upper or lower case: Ctrl+Shift+= and Ctrl+=, respectively.

Another way to write a formula with a not very complex structure is to use symbols (Insert - Symbol). The Symbol font contains, for example, Greek letters, which are often found in mathematical equations, as well as .

Using the Microsoft Equation Editor

To create more complex formulas, you have to use special editors that are included with the program. The Microsoft Equation 3.0 editor has proven itself well, which is a truncated version of the “Math Type” program and is included with old and new versions of Word. To insert a formula in Word using this tool, you need to find it in the objects menu:


If you frequently work with formulas, it can be quite inconvenient to open the Microsoft Equation 3.0 editor each time through the “Object” menu. For users of new versions (2007, 2010), the problem of how to insert a formula is solved much faster, since the developers themselves have placed the “Formula” button on one of the “Insert” panels. This tool is called “Formula Builder”, does not require opening a new window and allows you to do the same operations as the previous editor.

“Formula Builder” allows you not only to create your own formulas, but also to use a set of templates; To view them, you need to click on the triangle-arrow next to the “Formula” button. The standard set contains, for example, the Pythagorean theorem, the quadratic equation, the area of ​​a circle, Newton's binomial and other equations popular in physics and mathematics.