[cjlatta]

I have a letter that we created in Word 2000 that I need to update. I can't
open the document in Word 2003, so I'm recreating it. The document contains
several merge fields. I want to perform a multiplication of a merge field
(which is a number) by a set number (in the example it's 35). I used the
{=35*{mergefield xxx}\#,0.00\*Mergeformat} in Word2000, but I can't get it to
calculate in Word 2003. I know how to get the field codes - I just can't get
the multiplication to work. Also, I have another calculation to do - that is
a subtraction. It subtracts another mergefield from the results of the
formula listed above.
Any help would be appreciated.

[Doug Robbins - Word MVP]

You will need to do something to cause the fields to update. Either use
Ctrl+A to select everything and then use F9, or in the ToolsOptionsPrint
tab dialog, check the box to update fields when printing.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cjlatta" wrote in message
...
I have a letter that we created in Word 2000 that I need to update. I
can't
open the document in Word 2003, so I'm recreating it. The document
contains
several merge fields. I want to perform a multiplication of a merge field
(which is a number) by a set number (in the example it's 35). I used the
{=35*{mergefield xxx}\#,0.00\*Mergeformat} in Word2000, but I can't get it
to
calculate in Word 2003. I know how to get the field codes - I just can't
get
the multiplication to work. Also, I have another calculation to do - that
is
a subtraction. It subtracts another mergefield from the results of the
formula listed above.
Any help would be appreciated.

[cjlatta]

I'm not sure this will work, but I'll give it a shot. Since I'm doing the
recreation route, I think where my trouble lies is in the actual calculation
portion of the formula - I can't get the additional bracket into the formula
and thus get the multiplication to work.
Thanks though - I'll give it a try.

"Doug Robbins - Word MVP" wrote:

You will need to do something to cause the fields to update. Either use
Ctrl+A to select everything and then use F9, or in the ToolsOptionsPrint
tab dialog, check the box to update fields when printing.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cjlatta" wrote in message
...
I have a letter that we created in Word 2000 that I need to update. I
can't
open the document in Word 2003, so I'm recreating it. The document
contains
several merge fields. I want to perform a multiplication of a merge field
(which is a number) by a set number (in the example it's 35). I used the
{=35*{mergefield xxx}\#,0.00\*Mergeformat} in Word2000, but I can't get it
to
calculate in Word 2003. I know how to get the field codes - I just can't
get
the multiplication to work. Also, I have another calculation to do - that
is
a subtraction. It subtracts another mergefield from the results of the
formula listed above.
Any help would be appreciated.

[cjlatta]

Duh! - found my answer - if you don't make it a formula (insert/formula), it
won't work!
Thanks, Doug, for your suggestions - I'll keep them for future use.

"cjlatta" wrote:

I'm not sure this will work, but I'll give it a shot. Since I'm doing the
recreation route, I think where my trouble lies is in the actual calculation
portion of the formula - I can't get the additional bracket into the formula
and thus get the multiplication to work.
Thanks though - I'll give it a try.

"Doug Robbins - Word MVP" wrote:

You will need to do something to cause the fields to update. Either use
Ctrl+A to select everything and then use F9, or in the ToolsOptionsPrint
tab dialog, check the box to update fields when printing.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cjlatta" wrote in message
...
I have a letter that we created in Word 2000 that I need to update. I
can't
open the document in Word 2003, so I'm recreating it. The document
contains
several merge fields. I want to perform a multiplication of a merge field
(which is a number) by a set number (in the example it's 35). I used the
{=35*{mergefield xxx}\#,0.00\*Mergeformat} in Word2000, but I can't get it
to
calculate in Word 2003. I know how to get the field codes - I just can't
get
the multiplication to work. Also, I have another calculation to do - that
is
a subtraction. It subtracts another mergefield from the results of the
formula listed above.
Any help would be appreciated.

[Doug Robbins - Word MVP]

Sure, you need to use Ctrl+F9 to insert each pair of field delimiters { }.
Entering them by the use of the keys with those symbols on them on the
keyboard will not result in the creation of an field.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cjlatta" wrote in message
...
Duh! - found my answer - if you don't make it a formula (insert/formula),
it
won't work!
Thanks, Doug, for your suggestions - I'll keep them for future use.

"cjlatta" wrote:

I'm not sure this will work, but I'll give it a shot. Since I'm doing
the
recreation route, I think where my trouble lies is in the actual
calculation
portion of the formula - I can't get the additional bracket into the
formula
and thus get the multiplication to work.
Thanks though - I'll give it a try.

"Doug Robbins - Word MVP" wrote:

You will need to do something to cause the fields to update. Either
use
Ctrl+A to select everything and then use F9, or in the
ToolsOptionsPrint
tab dialog, check the box to update fields when printing.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"cjlatta" wrote in message
...
I have a letter that we created in Word 2000 that I need to update. I
can't
open the document in Word 2003, so I'm recreating it. The document
contains
several merge fields. I want to perform a multiplication of a merge
field
(which is a number) by a set number (in the example it's 35). I used
the
{=35*{mergefield xxx}\#,0.00\*Mergeformat} in Word2000, but I can't
get it
to
calculate in Word 2003. I know how to get the field codes - I just
can't
get
the multiplication to work. Also, I have another calculation to do -
that
is
a subtraction. It subtracts another mergefield from the results of
the
formula listed above.
Any help would be appreciated.

[thatangrykid]

Hi,
I've been smashing my head against the cube wall for the past few days
trying to get a calculation out of the mail merge fields I have set up in a
table. I have harnessed the power of =SUM(ABOVE) to get my Grand Total, and
I also discovered the Bookmark function so that the users can enter in the
number of years the deal is for and have used that number for calculations.
But in order to express the Total for each product, I can't seem to figure
out a way to take the Bookmarked quantity number and multiply it by the Unit
Price without getting an error message during the merge.

[WordBanter AI]

Hi there! I'd be happy to help you with your merge field calculations in Word 2003.

To perform a multiplication of a merge field by a set number, you can use the following syntax:

1. {=mergefield xxx * 35}

Make sure to include the equal sign at the beginning and the curly braces around the entire field code. Replace "mergefield xxx" with the name of your merge field.

To format the result with two decimal places, you can add the following switch at the end of the field code:

1. \#0.00

So the complete field code would look like this:

1. {=mergefield xxx * 35 \#0.00}

To subtract another merge field from the result, you can use the following syntax:

1. {=mergefield xxx * 35 - mergefield yyy}

Again, replace "mergefield xxx" and "mergefield yyy" with the names of your merge fields.