I work in a law firm and am attempting to create a document which calculates formulas.

This is what I need:



I have a paragraph based on IF/THEN - If there is child support involved, then we need to subtract that number from a number above. The number above is

{ =((settlefee)-(costs)-(settlefee*25%)) \# "$#,##0.00;($#,##0.00)" \*DollarText \*Upper }

This formula works. I want to be able to bookmark the formula result and put it in my IF/THEN paragraph with another formula. That formula would be the result above less the child support. So, I want something to the tune of { =resultabove-support }.

Is there a way to do this?

You should be able to select the formula and bookmark it (e.g., bmRA)

Then used {={bmRA}-support} with support, I assume is some number.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Thanks Greg - I did try to bookmark the formula, but when I ran the merge, it simply placed the formula, and not the numerical result, in the document where I placed the bookmark. I may be trying to pick up the formula from the wrong spot.

Because you're using DollaText, the field output is text and you'll not be able to use the bookmarked result as the input to another formula. However, a change to the field code will allow you to overcome that. Simplify the calculation and embed it in its own field, thus:
{={=settlefee*0.75-costs \# 0.00} \*DollarText \*Upper }
and bookmark the portion in red. Note that the braces (ie {}) ecompassing the red portion are field braces, which you create via Ctrl-F9.

Alternatively, create a SET field to hold the calculation and refer to the SET field's bookmark for both purposes:
{SET Result {=settlefee*0.75-costs \# 0.00}}
{REF Result \*DollarText \*Upper} - for the existing output
{=Result-Support \*DollarText \*Upper} - for the additional output

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]