Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I create a formula in a table in a word doc?
I ahve this projrct that I am working on for work and it is easier done in
word. I just do not know how to do the formulas like they are in excel? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I create a formula in a table in a word doc?
Actually, the easiest approach is to create the formulas in Excel and then
embed the Excel worksheet in Word. If you want to do the calculations in Word, you will have to use fields, which can be inserted via the Formula dialog box. To display the dialog box, click Formula on the Table Tools: Layout ribbon tab (Word 2007) or use Table | Formula (Word 2003). For more, see this (from Word Help): ************* Perform calculations in a table Applies to: Microsoft Office Word 2003 Do any of the following: Total the numbers in a row or column 1.. Click the cell (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.) in which you want the sum to appear. 2.. On the Table menu, click Formula. 3.. If the cell you selected is at the bottom of a column of numbers, Microsoft Word proposes the formula =SUM(ABOVE). Click OK if this is correct. If the cell you selected is at the right end of a row of numbers, Word proposes the formula =SUM(LEFT). Click OK if this is correct. Notes a.. If you see codes between braces— for example, {=SUM(LEFT)}— instead of the actual sum, Word is displaying field codes (field code: Placeholder text that shows where specified information from your data source will appear; the elements in a field that generate a field's result. The field code includes the field characters, field type, and instructions.). To display field code results, press SHIFT+F9. b.. If your column or row contains blank cells, Word will not total the entire column or row. To total the entire row or column, type a zero in each blank cell. c.. To quickly total a row or column of numbers, click the cell where you want the sum, and then click AutoSum on the Tables and Borders toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.). Perform other calculations in a table 1.. Click the cell (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.) in which you want the result to appear. 2.. On the Table menu, click Formula. 3.. If Microsoft Word proposes a formula that you do not want to use, delete it from the Formula box. Do not delete the equal sign. If you deleted the equal sign, reinsert it. 4.. In the Paste function box, click a function. For instance, to add numbers, click SUM. To reference the contents of a table cell, type the cell references in the parentheses in the formula. For instance, to add the numbers in cells A1 and B4, the formula would read =SUM(a1,b4) 5.. In the Number format box, enter a format for the numbers. For example, to display the numbers as a decimal percentage, click 0.00%. Note Word inserts the result of the calculation as a field in the cell you selected. If you change the values in the referenced cells, you can update the calculation by selecting the field and then pressing F9. Note Microsoft Word table (table: One or more rows of cells commonly used to display numbers and other items for quick reference and analysis. Items in a table are organized into rows and columns.) calculations must be manually recalculated. Consider using Microsoft Excel to perform complex calculations. ************* -- Stefan Blom Microsoft Word MVP "Melissa" wrote in message ... I ahve this projrct that I am working on for work and it is easier done in word. I just do not know how to do the formulas like they are in excel? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I create a formula in a table in a word doc?
Hi Melissa,
Word's formula functions are much more limited than Excel's but, to see the kind of thing you can do, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Melissa" wrote in message ... I ahve this projrct that I am working on for work and it is easier done in word. I just do not know how to do the formulas like they are in excel? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can word do this formula =EXP(B2) in a table? | Tables | |||
what is the formula for word to create automatic numbering in a . | Microsoft Word Help | |||
how do create a mathematical formula in word | Microsoft Word Help | |||
How do I set up a formula in a table in Word? | Tables | |||
How do you create a formula in a table where the result appears a. | Tables |