×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Formula in Microsoft Word Mergefield

Formula in Microsoft Word Mergefield

Formula in Microsoft Word Mergefield

(OP)
Hi there guys, I'm having an issue with a document and merge fields. Please excuse my nontech approach. I'm new at this and don quite know how to ask my question.

I'm using cloud software that uses MS Word as the Quote and Invoice template. Mergefield are the variables.

I want to give my clients 5% discount on the quoted amount is they upfront. I want to show them the actual amount including the 5% discount. How will I add the formula to the Word Doc.

The Mergfield is:

«InvoiceAmountDue»

If I Toggle Field Codes this is the Info:

{ MERGEFIELD InvoiceAmountDue \# "#,##0.00;(#,##0.00)" \* MERGEFORMAT}

Can someone perhaps assist me to get this formula working? I have tried everything but keep getting a syntax error

Regards


RE: Formula in Microsoft Word Mergefield

Hi,


{={MERGEFIELD InvoiceAmountDue}*0.95}

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Formula in Microsoft Word Mergefield

(OP)
Hi SkipVought,

If I use your formula and update field it still gives

!Syntax Error, {

RE: Formula in Microsoft Word Mergefield

1. Insert your mergefield:
«InvoiceAmountDue»
2. Select the mergefield and press Ctrl-F9, so you get:
{«InvoiceAmountDue»}
3. Fill in the formula, so you get:
{=«InvoiceAmountDue»*0.95 \# ",0.00;(,0.00)"}
Note: don't expect the formula to display or calculate correctly unless you preview or complete the merge.

Cheers
Paul Edstein
[MS MVP - Word]

RE: Formula in Microsoft Word Mergefield

(OP)
Hi macropod

Thank you so much for your assistance. but for the life of me I cannot get to display. I have managed at on point to not show an error but on then it would display !Undefined Bookmark,

I have attached the docx file

The Blue Total is the Quoted Amount
And the Red Discounted Amount should Display the Normal Total Less 5%

I hope can assist....

RE: Formula in Microsoft Word Mergefield

Follow macropod's instructions...


Naturally, I had to mock up some data to "merge" my invoice of 100.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Formula in Microsoft Word Mergefield

Your document is horribly structured. I can't imagine why you would embed the table in a textbox instead of simply putting the table in the document body.

In any event, your '!Undefined Bookmark' and any other errors result from not following the very simple instructions.

Cheers
Paul Edstein
[MS MVP - Word]

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close