how can I perform a math funcion in word

  • Thread starter Thread starter Edwin (Borinquen)
  • Start date Start date
E

Edwin (Borinquen)

Just want to know how can I perform a math function within a letter, vis a
vis, the letter tells you you owe x amount but with a 50% discount you would
pay X amount
 
You can use formula fields to perform (simple) calculations. For example,
{ = 0,5*100 } would display 50.

To insert the field delimiters, { }, press Ctrl+F9; then type the code. Use
F9 to update all fields in the selection. If you want to show/hide all field
codes in a document, use Alt+F9.
 
To clarify: You should of course use the decimal sign that is defined by
your regional settings. It may very well be something different than a comma
as I used in my example. :-)
 
Hi,

In addition to Stefan's suggestion, you can bookmark the original amount due
and the discount rate and use the bookmarks in the formula field.

For example, in the following sentence select 100 and create a bookmark
called AmountDue, and select 25 and create a bookmark called DiscountRate.

You owe $200, but with a 25% discount you would
need to pay only $.

Then after the the last dollar sign ($), add the following field codes.
{={ AmountDue } - { AmountDue }*{ DisountRate }/100}

As Stefan mentioned, to create each pair of field delimeters, do not type
the curly brackets. Instead, select what they will enclose and press Ctrl+F9.
After you finish creating the field codes, press F9 and then press Alt+F9.
The number 150 should appear.
 
And neither version will work if the spelling of DiscountRate in the
calculation doesn't match the spelling of the bookmark name ;)

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


macropod said:
Hi Pesach,

A simpler rendition would be:
{={ AmountDue }*(1-{ DisountRate }/100)}


--
Cheers
macropod
[Microsoft MVP - Word]


Pesach Shelnitz said:
Hi,

In addition to Stefan's suggestion, you can bookmark the original amount
due and the discount rate and use the bookmarks in the formula field.

For example, in the following sentence select 100 and create a bookmark
called AmountDue, and select 25 and create a bookmark called
DiscountRate.

You owe $200, but with a 25% discount you would need to pay only $.

Then after the the last dollar sign ($), add the following field codes.
{={ AmountDue } - { AmountDue }*{ DisountRate }/100}

As Stefan mentioned, to create each pair of field delimeters, do not type
the curly brackets. Instead, select what they will enclose and press
Ctrl+F9. After you finish creating the field codes, press F9 and then
press Alt+F9. The number 150 should appear.
Click to expand...
Click to expand...
 
Back
Top