• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 993
  • Last Modified:

WORD 2007 calculation / spreadsheet capabilities within a table

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
Need-a-Clue
Asked:
Need-a-Clue
  • 2
  • 2
1 Solution
 
samiriseCommented:
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
 
Need-a-ClueRESEARCHERAuthor Commented:
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
 
samiriseCommented:
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
 
Need-a-ClueRESEARCHERAuthor Commented:
samirise:

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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now