#### Inserting a formula into a Word Table

```How do you insert a multiplication formula in the last cell of a Word Table
so that it only multiples the two previous cells, or the is there a way to
pick the cells that you want it to use for the formula?
```
 0
Utf
2/16/2010 3:20:01 PM
word.docmanagement 5542 articles. 1 followers.

2 Replies
2766 Views

Similar Articles

[PageSpeed] 37

```Insert a formula field and do the calculations as you would in Excel. For
example: { = A1*A2 } would multiply the values in cell A1 and A2.

To insert the field delimiters, { }, press Ctrl+F9. Type in the code. Use F9
to update the result. To show/hide field codes in the selection, use
Shift+F9. To show/hide field codes in the whole document, use Alt+F9.

Note that table calculations are easier if you make use of an embedded Excel

--
Stefan Blom
Microsoft Word MVP

"jontimber" <jontimber@discussions.microsoft.com> wrote in message
news:1B6BC403-75FB-41F1-844E-C333CCE2254D@microsoft.com...
> How do you insert a multiplication formula in the last cell of a Word
> Table
> so that it only multiples the two previous cells, or the is there a way to
> pick the cells that you want it to use for the formula?

```
 0
Stefan
2/16/2010 3:36:09 PM
```Hi jontimber,

To see how to do a wide range of calculations in Word, whether using tables or otherwise, check out my Word Field Maths Tutorial,
at:
http://lounge.windowssecrets.com/index.php?showtopic=365442
or

--
Cheers
macropod
[Microsoft MVP - Word]

"jontimber" <jontimber@discussions.microsoft.com> wrote in message news:1B6BC403-75FB-41F1-844E-C333CCE2254D@microsoft.com...
> How do you insert a multiplication formula in the last cell of a Word Table
> so that it only multiples the two previous cells, or the is there a way to
> pick the cells that you want it to use for the formula?

```
 0
macropod
2/16/2010 8:56:25 PM

Similar Artilces:

Removing words from the standard dictionary
I'm the sort of person who spells role as r�le and I've often wondered if a mechanism exists to remove the word "role" from the standard dictionary, or perhaps override it somehow, with my preferred spelling. Similarly, I never find a use for the word "poser" in my business communications, but frequently type it in place of "power", with unfortunate consequences. So I'd remove "poser" from the dictionary as well. Is there hope for me, and my Office 2003? -- Steve Swift http://www.ringers.org.uk (Personal Webpage) http://hedgeh...

Inserting rows into sheet that contains a formula
I have a typical financial sheet where the columns sum (sum(a5:a15)) and the rows sum (sum(a5:h5)). The summation columns are locked and the sheet protected. Is there a technique whereby I can have the user insert a row which will keep the formats and row sum as well as changing the formula in the column sums? Thanks. Rick Hi Rick, The following method is not foolproof but generally it works OK. Insert a blank row between the bottom of data to be summed and the row with the sum formulas. Include the blank row in the sum formula. Protect the blank row along with the formulas and what...

Word e-mail message window stops responding
Hello MS Word 2002 e-mail message window stops responding after coping and pasting in it. The Word is chosen in Outlook as an e-mail editor. The window appeared after clicking reply in the Outlook. -- Please, inform me of your reply: click Message menu, then 'Reply to all' in Outlook Express (this sends your reply to the newsgroups and to my email address at the same time) or inform me by sms to 79163876746 from www.mts.ru/sms or to my ICQ#135557327 or by messenger to kopnichev@hotmail.com Mr. Dmitriy Kopnichev e-mail: kopn@hotbox.ru Dimitry, - Upgrade to the latest service pack ...

Convert a word address and data list to excell
I help with a food pantry and the existing cliant data list was created in word seperated by commas. I am told to put all 1500 or so cliants in to note pad, then put them on one line (data of each cliant seporated by 7 commas and their children seporated by ;) then I can put them into excell. Well I am only up to the C's and have been doing it for 3 weeks now. Plus we keep adding new ones every week which are not in order now. If anyone could help me with this I would so appreciate it. Thank you Beverly Hi if they're still in Word, select the list and choose edit / replace in...

clip art inserted into business card prints solid black box
I have entered clip art into a business card, it shows up fine on "Print Preview" but when it actually prints, it is a solid black box. What format is the image? High-resolution pictures can cause this especially if they are a 48 bit tiff. Import the clipart into an editing program and change the image resolution. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Mendy" <Mendy@discussions.microsoft.com> wrote in message news:54608BE3-54BC-4D0...

VBA: Insert Page Breaks code is not working in Excel 2010
I have a snippet of VBA code to insert page breaks after a particular row. This works fine in Excel 2007, but it doesn't in another Excel 2010 machine. It doesn't seem right to me that VBA code would behave differently in different versions of Excel. Am I missing something?? RE: Am I missing something?? Yes, your code. -- Regards Dave Hawley www.ozgrid.com "iswarya" <u59539@uwe> wrote in message news:a6e77011b51d5@uwe... >I have a snippet of VBA code to insert page breaks after a particular row. > This works fine in Excel 2007, but it doesn...

Conditional formating in pivot tables
Hi Is it possible to have conditional formatting on a field in a pivot table. I can apply conditional formatting to a range of cells, but if e.g. a wider range of data is produced the formatting doesn't grow with it. I don't want to have the 'Grand Total' columns have the same formatting as the rest of the sheet, but depending on what data is brought back, they're not necessarily in the same place. Am I making sense?! I'm using Excel 2002 Cheers Neil How many conditions will you have? If there's only one, you could check for "Grand Total" in the...

Macro that inserts lines
I have this macro that inserts a line if the value in D changes and copy the value in D to A. I want this macro to only start looking in D14 or from row 14. tx for all the help Dim row_index As Long Application.ScreenUpdating = False lastrow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For row_index = lastrow - 1 To 2 Step -1 If Cells(row_index, "D").Value <> _ Cells(row_index + 1, "D").Value Then Cells(row_index + 1, "D").EntireRow.Insert _ (xlShiftDown) Cells(row_index + 1, 1).Value = Cells(row_index + ...

Inserting a Flash Animation on an email
How can insert a flash animation to an email. Where does .swf file has to be so the person that receive the email can see the animation? Regards, Jessie ...

CListCtrl slowing down after several insert's/delete's
Hello, Here's a twist on a classic question on CListCtrl being slow to remove thousands of records. I'll first described the setup then the various tests I did. The program is running on Win98, I guess on XP I won't even know if there's a difference, but I am curious about why it gets slower after multiple fill in a listctrl. I have an executable acting as the main program. Menu option calls a dialog box (call it DIALOG A) in a DLL which displays ~250 records. This listctrl loads in a flash. Upon selecting a record from the list, another window (call it DIALOG B) is di...

To copy a formula
How I can copy the formula T3-M3 into AA3 . The formula should be copied upto the end of the cell where the data ends from T3 cell. So please help to find out the lastrow from T3...Tn where data ends in that column With thanks and regards Pol I don't understand what it is that you are asking. Would you care to re-state your request with some sample data? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk "pol" <pol@discussions.microsoft.com> wrote in mess...

Insert File (Insert as Text) Into Contacts
I'm using O2003. I have a number of files I always insert into my contact's notes. By default, the Insert button on the "Insert File" dialog defaults to inserting the file. Is there a way to change this button to default to "Insert as text" thxs Shawn srm <srm@primatech.com> wrote: > I'm using O2003. I have a number of files I always insert into my > contact's notes. By default, the Insert button on the "Insert File" > dialog defaults to inserting the file. Is there a way to change this > button to default to "Inse...

formulas #7
i have a spread sheet i use to calculate percentages and then take those to find a rolling average. here is an example of my problem: column "a" is the amount correct, column "b" is the amount wrong, column "c" is the perctage of "a & b", column "d" is the rolling average. a1=10, b1=1, c1=90%, d1=90%...a2=10, b2=2, c2=80%, d2=85% (the average of d1 and d2)...a3=0, b=0, c3=#div/0!, d3=#div/0!...a4=10, b4=3, c4=70%, d4=#div/0! what i need to do is make d3= d2's value and for d4 to average d1-d4 but skip any with a null or 0 value (ie....

Unable to insert record in table
Hi, Using SQL Server 2005. I have a table with one required field (key field, var type int) and various other optional fields. Yesterday, my Access VBA code failed to action the following SQL statement: INSERT INTO ORDERS (OrderID) VALUES (9121165) I got a time out error and a report that the record could not be inserted (error code -2147217887). So I opened SQL Server Managment studio and opened the table. When I tried to insert a new record using the same OrderId, I first got a timeout error and could not add the record. AFter OK'ing the error, I was able to cli...

Sql insert statment from from list box to table or form
I have the following list box called list0 with the following in row source. SELECT tblCityStateZip.City, tblCityStateZip.State, tblCityStateZip.Zip FROM tblCityStateZip; i have a form called frmpeople with the following PeopleID LastName FirstName Address City State Zip(Combo Box) SELECT tblCityStateZip.Zip, tblCityStateZip.City, tblCityStateZip.State FROM tblCityStateZip; What i want to do is when user double clicks on city state zip in the list box will insert those in the form called people where it says City,State,Zip. Any ideas. Jeremy, Well, is the list0 listbox also on ...

inserting emoticons
how do I insert those little faces in my emails in outlook express? Try posting this in an Outlook Express news group - this is not one of them. Outlook is a part of Microsoft Office and is what this group supports. Outlook Express is a part of Internet Explorer and has its own news groups. You can also find some good Outlook Express information here: http://www.insideoutlookexpress.com/ -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. ALWAYS post your Outlook version. How to ask a question: http://support.microsoft.com/KB/555375 After f...

Word uses up a lot of memory
When I open a file of Word97-03, it uses up a lot of memory. eg. My RAM is 4GB and it uses up 1,002,188K for WINWORD.EXE Sorry, but this newsgroup is for questions about Access, the database product that's part of Office Professional. You'd be best off reposting your question to a newsgroup related to Word. Should you do that, it might help the responder to know more about your setup. What version of Word are you using? What Operating System? What else is running at the same time and so on. Good luck! -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele...

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi. I'm a relative newcomer to Word for Mac (and an unschooled user of Word for PCs). <br><br>I'm trying to generate a TOC for an existing 26-page legal document. Heading 2 is a short phrase followed by a period. Paragraph follows. Example: <br><br>5.1. Taxes. Tenant shall have no responsibility for payment of any kind or portion of real property taxes or assessments with respect to the Premises or the real property upon which the Premises are situated. <br><br>When ...

Why won't word alphabetize a list of email addresses?
I typed a list of single spaced email addresses separated by paragraphs and want to alphabetize them. When I try, I get an error message "Word cannot sort fields in the selections." How can I sort this list? Thanks!!! In the Sort dialog, for "Sort by," make sure you have "Paragraphs" selected instead of "Field 1" or anything else. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Sort list of email addresses" <Sort list of email addresses@discussions.microsoft.com&...

Date Formula Help
Someone here once gave me the formula for converting a Date to the number of the week. In other words 1/16 would be 3 as it falls on the 3 week of the year. Would anyone hapen to know that formula. I lost it. Thanks for the help. Steve Hi Steve! See: Chip Pearson: http://www.cpearson.com/excel/weeknum.htm A variety of formulas for use with vary definitions of week number. -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Norman, thank you very much this was the artical i was looking for. :) "Norman Harker" <njharker@optusnet.com.au> ...

pivot table
How do you use the Rank formula in a pivot table Hi AFAIK you can't -- Regards Frank Kabel Frankfurt, Germany "A Lesner" <A Lesner@discussions.microsoft.com> schrieb im Newsbeitrag news:C1803CAE-854C-4EEF-9810-A81B898B83D4@microsoft.com... > How do you use the Rank formula in a pivot table Is there a workaround for ranking in a pivot table? It seems that if a pivot table can not rank, it severly limits it's use in the business world. "Frank Kabel" wrote: > Hi > AFAIK you can't > > -- > Regards > Frank Kabel > Frankfurt,...

Keep phone number fomatting from excel to print on WORD labels
With an older version of Microsoft Office when phone numbers in excel were formatted (555) 555-5555 and you mail merged them to a WORD label the formatting printed on to the label. The new version of these programs just types the numbers of 5555555555 without the ( ) and the -. I would like the formatting of the excel file to transfer to the WORD labels. If you format a cell as Special > Phone number and enter 1234567890 it will display as : (123) 456-7890 When the cell is copied and pasted into Word the formatting is preserved. -- Gary''s Student "Thelma Theiler&quo...

Insert File Path
In Word 2007, I would like to have either a shortcut key or a QAT button to insert the full file path of my document. I use this very frequently in the footer. File path and Insert file path commands are not available in Customize process. How can I do this? Save the field as an AutoText entry and assign a keyboard shortcut. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "gordo" <none@phony.net> wrote in message news:uFg6YFRoKHA.5696@TK2MSFTNGP04.phx.gbl... > In Word 2007, I would like to...

How do I insert a file into Excel 2007 spreadsheet ?
The old Excel command Insert-Object does not exist anymore, instead only these Insert {Tables | Illustrations | Charts | Links | Text } I want to insert a general application file, I pretended it is a .Jpg file by renaming it and attempting Insert - Illustration -From File, but of course this was rejected. I also tried using a macro, the essence of which was Set myPict = .Parent.Pictures.Insert("C:\MyFile.Dat.Jpg") but this had the same effect. I finally tried good old drag-and-drop into a cell, but this simply opened up the binary in a separate Excel window...

Adjust thickness of drawn lines in word 2008 for Mac
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hi, <br><br>The question has been posted before, but I still can't manage. <br><br>Every time I draw a line in Word for Mac it is a thick blue one, the color isn't very important to me, the thickness is. <br><br>So my question is: how can I adjust the thickness of the lines I draw permanently and for every new Word document I make? <br><br>Thanks in advance. <br> Bart In any given document you can format the shape as you wish then Control/Right-Click it & selec...