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?
samirise
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.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
samirise:
THANK YOU! THANK YOU! THANK YOU! I REALLY appreciate your efforts! Need-a-Clue
THANK YOU! THANK YOU! THANK YOU! I REALLY appreciate your efforts! Need-a-Clue