Solved

# WORD 2007 calculation / spreadsheet capabilities within a table

Posted on 2007-10-12
980 Views
I have created a table in Word. I have 8 columns and 25 rows. The rightmost three columns will contain only numeric information. Is it possible for me to enter all 25 values in the 6th column and have the cell immediately to the right of the entered figure automatically calculate 21% of the entered value and display it in the 7th column. To take it further I want the 8th column to show the remainder of the calculation. To clarify: On row one column 6 I would enter 100. Automatically column 7 would show 21 and then column 8 would show 79. Is this possible? I KNOW that excel would be best for this but I have a time constraint and I cannot learn Excel or another program to do this for me. Hoping it can be done. Can it?
0
Question by:Need-a-Clue

LVL 2

Expert Comment

Not to beat a dead horse, but Excel is a quickie fix for this issue. if you type all the contents of column 6 in Excel (just go right down the line) then type exactly the following in the next column:  =sum(a1*.21) and then in the 3rd (8th) column type =sum(a1*.79) then you can drag and drop that cell all the way down to fill in the values.  I can help you more with this if you like, but when you are all done simply highlight the three columns and paste them over the 3 columns you want them in Word.  If you absolutely dont want to try Excel, I will have to get back to you.
0

Author Comment

HI SAMRISE, The problem is that I must enter data partially in advance (text) then ALL the numeric data as items are appraised after opening. So, I can't do it all at one time. I'm far more familiar with Word than Excel. It is critical that I be able to expediently and accurately enter the data under pressure.
0

LVL 2

Accepted Solution

Okay, here is the formula for WORD... very similar to Excel as I mentioned before:

in the column to the right of the number you want to caculate click on Table > FORMULA in the top box, type, =SUM(LEFT)*.21
In the column to the right of that one, use the formula box and type the same except: =SUM(LEFT)*.79

Here's a link that explains in more detail:
http://jwolsen.com/wtip067.htm

0

Author Comment

samirise:

THANK YOU! THANK YOU! THANK YOU! I REALLY appreciate your efforts!  Need-a-Clue
0

## Featured Post

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text: