Adding two merge fields together in a Word document

Topic

New Reply

I am creating a bid sheet which will have the starting bid $amt and adding the increment amounts on the next lines. I will be uploading the Word document to an online program (Greater Giving) which will do the actual merge.

This is what I think is correct for the first line, but I keep getting !Syntax Error, + when I hit F9 when I’m done. I tried uploading and merging the document, but it didn’t work at all.

Yes, I am using ctrl+f9 to create the {}, and using the Insert Merge field to create the «»

{ = { «PackageMinimumBid» } + { «PackageMinimumRaise» } \# $,0.00 }

The next line is basically the same, but I need to multiply the PackageMinimumRaise by 2. Not sure how to do that.

The output should be something like:
Line 1 = $70.00 (PackageMinimumBid)
Line 2 = $75.00 (PackageMinimumBid + PackageMinimumRaise)
Line 3 = $80.00 ((PackageMinimumBid) + (PackageMinimumRaise*2))

Thank you for your help!

 

Reply | Quote

Replies

This works, but may not look exactly like you want.

0. Create a 2 x 2 table.
1. Row1Col1: {seq index \r 1}
2. Row1Col2: {set PackageMinimumBid 70}{set PackageMinimumRaise 5}{PackageMinimumBid}
3. Row2Col1: {seq index}
4. Row2Col2: {={PackageMinimumBid}+{PackageMinimumRaise}*({seq index \c}-1)}
5. Copy row 2 and paste as many times as you like to the bottom of the table
6. Update

Explanation of the introduced elements:
1. {seq index \r 1} Creates a sequence with name ‘index’ (you can choose whatever you want) and sets the starting value to 1.
3. {seq index} Increments the ‘index’ by 1
4. ({seq index \c}-1) uses the current value of index. We subtract 1 as the we started the index at 1 so the first increment is 2. If we didn’t subtract the 1 the amounts would be 70, 80, 85 rather than 70, 75, 80.

Obviously you can include whatever text you want on either side of the fields.

Reply | Quote

Further to the above… the merge fields don’t need to be in a table – I just did that to make the explanation easier.

If you don’t want to see the index number at all, you can add ‘\h’ to the end of all the seq fields and it will hide the index numbers.

The attached document illustrates this.

Reply | Quote

@TeresaM, did the above help at all or are you still having issues?

Reply | Quote