Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I subtract two merge fields then take that total and divide
I want to take my two merge field and divide them by 50% or by two. I can
get the subtracting part but it does not want to divide. I tried {total = {Mergefield Original Debt} - {Mergefield Paid to Date} / 2} this will only give me the subtraction but not the division part. Also I want the answer to read in a dollar format instead of decimal format. Can anyone help? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I subtract two merge fields then take that total and divide
Use parentheses so that Word knows to divide the difference:
{ = ({Mergefield Original Debt} - {Mergefield Paid to Date}) / 2} As shown in your example (not sure why "total" is there -- it should not be, and it's likely changing the result), it's doing the following: OriginalDebt - (PaidToDate/2) That's because multiplication is evaluated before subtraction. By grouping using parentheses, you can control how the expression is evaluated. -- Herb Tyson MS MVP Author of the Word 2007 Bible Blog: http://word2007bible.herbtyson.com Web: http://www.herbtyson.com "tddrover" wrote in message ... I want to take my two merge field and divide them by 50% or by two. I can get the subtracting part but it does not want to divide. I tried {total = {Mergefield Original Debt} - {Mergefield Paid to Date} / 2} this will only give me the subtraction but not the division part. Also I want the answer to read in a dollar format instead of decimal format. Can anyone help? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I subtract two merge fields then take that total and divide
{ = ({ MERGEFIELD Original Debt } - { MERGEFIELD Paid to Date }) / 2 \#
"$,0.00" } You must use Ctrl+F9 for each pair of Field Delimiters { } -- 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 "tddrover" wrote in message ... I want to take my two merge field and divide them by 50% or by two. I can get the subtracting part but it does not want to divide. I tried {total = {Mergefield Original Debt} - {Mergefield Paid to Date} / 2} this will only give me the subtraction but not the division part. Also I want the answer to read in a dollar format instead of decimal format. Can anyone help? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I subtract two merge fields then take that total and divide
Thank you very much!! Worked great.
"tddrover" wrote: I want to take my two merge field and divide them by 50% or by two. I can get the subtracting part but it does not want to divide. I tried {total = {Mergefield Original Debt} - {Mergefield Paid to Date} / 2} this will only give me the subtraction but not the division part. Also I want the answer to read in a dollar format instead of decimal format. Can anyone help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract formula | Tables | |||
WHAT HAPPENED TO THE FORMULAS/ADD AND SUBTRACT | Microsoft Word Help | |||
how do you write the subtract sign | Microsoft Word Help | |||
total yes and no text fields | Microsoft Word Help | |||
Formula in table - Creating a final total from sub-total cells | Tables |