Formula in Microsoft Word Mergefield

[simonmillersa]

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

 

[SkipVought]

Hi,

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

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

 

[simonmillersa]

Hi SkipVought,

If I use your formula and update field it still gives

!Syntax Error, {

 

[macropod]

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]

 

[simonmillersa]

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....

 

[SkipVought]

Follow macropod's instructions...

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

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

 

[macropod]

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]