Formulas

[Jesse]

Can I set up a table so that it automatically calculates a
formula, like Excel, or do I need to manually enter the
formula each time? Thanks!

 

[mparks]

with your cursor in the cell
tables -> formula -> then type in your formul

you will need to save the document if you want to be able to reuse it.

----- Jesse wrote: ----

Can I set up a table so that it automatically calculates
formula, like Excel, or do I need to manually enter th
formula each time? Thanks

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

You can insert an Excel Spreadsheet into a Word document instead of using a
Word table, or use formfields in the table.

See - Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Guest]

I've tried using Formfields, and they work once when I
enter a formula, but when I erase the data and then enter
new data, the field does not calculate. I'm trying to
create an invoice that calculates amount X price = total
price. For example, I use the formula =A2*D2 and I get the
proper amount, but then I enter new amounts and my formula
disappears. Thanks for the help.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Check the Calculate on Exit box for the formfields that contribute to the
result.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP