How can I save formulas in a Word template cell so they automatically do calculations for me?

By saving the template with the formulae in-situ.
To see how to do a wide range of 'math' calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...l=1#post320143
or
http://www.gmayor.com/downloads.htm#Third_party
Similarly, to see how to do just about every calculation you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at:http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party

Do read both documents' introductory material.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks I have managed to add some formulas, after reading your articles, to some of my columns.

I have run into another problem. I want to add a formula to a row. I have an invoice with 6 columns, the first is Qty, the fourth is Unit Price, the Fifth is Discount and the sixth is Line Total. My first row has headings and the second has amounts. I want to multiply Qty by Unit Price and Subtract the Discount column. I have tried putting in some formulas but they don't work?

Hi bondimedical,

Without seeing your document and the formulae you're trying to use, I can't say what the issues are. You can attach a document to a post via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul

I have attached a copy of the invoice.

Attached Files

Andro2Invoice.docx (59.6 KB, 9 views)

Hi bondimedical,

Personally, I'd do this in Excel. It'd be far simpler.

Your existing formlae have some problems. Did you notice how, with no line totals your invoice has values in the sub-total, GST & total cells? That's courtesy of SUM(ABOVE) trying to add up the numbers in the date, customer ID, etc. Splitting the table above the 'line total' row will solve that. However, I'd strongly recommend against using SUM(ABOVE) anyway, for the reasons outlined in the Maths tutorial.

As for calculating each row's line total, you'll need a formula field like:
{=A$$*D$$-E$$ \# "0.00;;"}
in each 'line total' cell, where $$ is the row number. Even then, unless you're using formfields with the 'calculate on exit' attribute set in columns A,D&E, the values won't automatically recalculate. See attached.

Attached Files

AndroInvoice.docx (61.9 KB, 12 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul

I have split my tables and now the subtotals show 0.0

My biggest problem with the row formula was correct cell address. I used the macro "CellAddress" in the Maths tutorial to find the correct row numbers and now it's all working correctly.

I know now what you mean by preferring Excel for this. Is there a simple way to convert a Word document into an Excel document?

Hi bondimedical,
You could simply select the table, then copy & paste into Excel. You might want to paste into cell B2. You'll need to re-create all the formula, etc, but that's pretty easy in Excel.

If you look at the document attached to my post, though, perhaps you'll decide transferring to Excel is no longer needed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]