Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula in Microsoft Word Mergefield

Status
Not open for further replies.

simonmillersa

Technical User
Sep 21, 2020
3
ZA
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


 
Hi,

[tt]
{={MERGEFIELD InvoiceAmountDue}*0.95}
[/tt]

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
Hi SkipVought,

If I use your formula and update field it still gives

!Syntax Error, {

 
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]
 
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....
 
 https://files.engineering.com/getfile.aspx?folder=8621b5f1-c37e-4517-a03b-c2e40a54d9e2&file=Quote_new6.docx
Follow macropod's instructions...
2020-09-24_rucxko.png


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

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top