how do i tranfer an excel chart to a word template with out loosing the formulas

  • Thread starter Thread starter Caesar
  • Start date Start date
C

Caesar

Dear all

i have made up a template on word for a new invoice for my business.
i have also made up a small basic chart with fomulas in excel so when i type
in a price and the quantity, excel multiplies it and totals it all up.

THE PROBLEM

i cant seem to tranfer the chart on excel to the word template with out
loosing all the formulas i have put in,


Can someone please tell me how i can do this with out loosing the formulas.

i would be very greatful for any suggestions ,

Best wishes

Caesar

--
 
I'm guessing that by 'chart' you mean a table of numbers and formulas:

Why not create a table in your Word template and put the formulas in there?

Word's tables have basic arithmetic and some other functions, and
formatting available.

Hint: Look in the Table menu in Word :)

Table > Insert... > Table
Table > Formula...
etc.


Mike Argy
Custom Office solutions and
Windows/UNIX applications
 
NO:




HEIGHT


WIDTH


DEPTH


CANVAS


FINISH




PRICE


QTY


SUB

TOTAL

1.










2.










3.










4.










5.










6.










7.










8.










9.










10.










11.










12.










13.










14.










15.












TOTAL:





I am trying to work out how to make formulas on word

I need each row in the subtotal colom to multiple the price on that row by
the qty.



Then I need the total at the bottom to add up all the subtotals





Can any one help please ,



I would be very greatful if you could do it for me and the email it back,
please email as a word doc if need be.



Thank you

Best wishes



Caesar
 
Caeser,

Assuming your subtotal column is on the right, select the cell and click
on Table > Formula...

The formula you want is =PRODUCT(LEFT). Format it with two decimal
places. Do this for all of your item lines. It is very important to
have an empty cell to the left of the numbers you want to multiply. (it
can be very narrow; it has to have no value in it. Word sees this as
the stop point for the multiplication.)

Assuming your total cell is at the bottom of your subtotal column,
insert the formula =SUM(ABOVE).

You should post your question on a Word newsgroup - they are more
familiar with what you are trying to do and will probably have a better
way to do it. I am more into using Excel and C/C++ programming than I
am into using Word.


Mike Argy
Custom Office solutions and
Windows/UNIX applications
 
Back
Top