embedding formulas in a Word document


I'd like to embed formulas in a Word document as follows:

Word Doc Sample:

"Mr. Smith has been approved for a loan in the amount of $80,000.  Including his down payment of $20,000, he qualifies for the purchase of a home up to $100,000."

...where the amounts $80,000 (80% of $100,000) and $20,000 (20% of $100,000) are automatically calculated by inputing the amount $100,000.  Also, I'd like the print out of this document to appear as though the amounts had been manually entered (i.e. no weird spacing before or after, above or below...).

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anne TroyEast Coast ManagerCommented:
You got it.

Where the $80,000 would appear, insert a text formfield (the ab| button on the forms toolbar). Double-click the form field and set it to be number/currency, and the desired format.
Give that one a bookmark named ApprAmt (or similar--must be ONE word).
Hit the "calculate on exit" checkbox

Now copy the form field.
Paste it where the $20,000 would be.
Double-click it.
Give it a bookmark name of DwnPmt
Hit the "calculate on exit" checkbox

Now, go where the $100,000 should appear.
Hit Insert-Field, choose Equations and formulas, and type this formula into the box "=ApprAmt+DwnPmt"

Now, to enter the $80K and the $20K, this document must be protected. Either use the padlock on the forms toolbar, which I like to use for testing, or use Tools-Protect Document, and choose Forms.

Now, when you type $80,000 in and hit tab, it'll already make your formula read $80,000.
Hit Tab, type in the $20,000, and hit tab, it'll make it read $100K.

If you DON'T want it to read just the $80,000, take the "calculate on exit" checkbox off of that formfield (of course you must unprotect the doc to work on the formfields again).

The doc ought to be saved in it's protected state, and saved as a template (DOT) file.

I hope that helps!
Anne TroyEast Coast ManagerCommented:
By the by...you've still got this question open: http://www.experts-exchange.com/Operating_Systems/WinXP/Q_20736148.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
madmagusAuthor Commented:
Works like a charm, thanks very much!
Anne TroyEast Coast ManagerCommented:
Way cool. :) Thanks for the grade!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.