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!

Register Log in
  • Congratulations bkrike 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

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


 
Sort by date Sort by votes
Hi,

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

Skip,

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

If I use your formula and update field it still gives

!Syntax Error, {

 
Upvote 0 Downvote
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]
 
Upvote 0 Downvote
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
Upvote 0 Downvote
Follow macropod's instructions...
2020-09-24_rucxko.png


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

Skip,

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

Similar threads

Avayacoolstuff
  • Locked
  • Question
Error codes Microsoft office
Replies
1
Views
453
dhookom
dhookom
pendle666
  • Locked
  • Question
Microsoft Word - removing index entries with find/replace and wildcards
Replies
4
Views
3K
pendle666
pendle666
AndrewMozley
  • Locked
  • Question
Autosave with Microsoft Word
Replies
2
Views
2K
Mike Lewis
Mike Lewis
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
913
bs6600
bs6600
Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
958
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top