WORD 2007 calculation / spreadsheet capabilities within a table

Posted on 2007-10-12
Last Modified: 2010-07-27
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?
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.

    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.
    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:  


    Author Comment


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

    Featured Post

    A Knowledge Base That Stays Up-to-Date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    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:

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now