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
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
{={MERGEFIELD InvoiceAmountDue}*0.95}
Skip,
Just traded in my OLD subtlety...
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
RE: Formula in Microsoft Word Mergefield
If I use your formula and update field it still gives
!Syntax Error, {
RE: Formula in Microsoft Word 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
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
Naturally, I had to mock up some data to "merge" my invoice of 100.
Skip,
Just traded in my OLD subtlety...
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
RE: Formula in Microsoft Word Mergefield
In any event, your '!Undefined Bookmark' and any other errors result from not following the very simple instructions.
Cheers
Paul Edstein
[MS MVP - Word]