how can I perform a math funcion in word

  • Thread starter Edwin (Borinquen)
  • 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
 
S

Stefan Blom

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.
 
S

Stefan Blom

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. :)
 
P

Pesach Shelnitz

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.
 
M

macropod

Hi Pesach,

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

Graham Mayor

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top