A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how can I perform a math funcion in word



 
 
Thread Tools Display Modes
  #1  
Old April 1st, 2010, 07:20 PM posted to microsoft.public.word.docmanagement
Edwin (Borinquen)
external usenet poster
 
Posts: 1
Default how can I perform a math funcion in word

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
  #2  
Old April 1st, 2010, 07:57 PM posted to microsoft.public.word.docmanagement
Stefan Blom[_3_]
external usenet poster
 
Posts: 4,556
Default how can I perform a math funcion in word

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.

--
Stefan Blom
Microsoft Word MVP



"Edwin (Borinquen)" Edwin wrote in
message ...
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



  #3  
Old April 1st, 2010, 08:07 PM posted to microsoft.public.word.docmanagement
Stefan Blom[_3_]
external usenet poster
 
Posts: 4,556
Default how can I perform a math funcion in word

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

--
Stefan Blom
Microsoft Word MVP



"Stefan Blom" wrote in message
...
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.

--
Stefan Blom
Microsoft Word MVP



"Edwin (Borinquen)" Edwin wrote in
message ...
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





  #4  
Old April 1st, 2010, 10:13 PM posted to microsoft.public.word.docmanagement
Pesach Shelnitz[_2_]
external usenet poster
 
Posts: 228
Default how can I perform a math funcion in word

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.

--
Hope this helps,
Pesach Shelnitz
My Web site: http://makeofficework.com


"Stefan Blom" wrote:

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

--
Stefan Blom
Microsoft Word MVP



"Stefan Blom" wrote in message
...
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.

--
Stefan Blom
Microsoft Word MVP



"Edwin (Borinquen)" Edwin wrote in
message ...
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





.

  #5  
Old April 1st, 2010, 10:23 PM posted to microsoft.public.word.docmanagement
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default how can I perform a math funcion in word

Hi Pesach,

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


--
Cheers
macropod
[Microsoft MVP - Word]


"Pesach Shelnitz" pesach18(AT)hotmail.com wrote in message ...
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.

--
Hope this helps,
Pesach Shelnitz
My Web site: http://makeofficework.com


"Stefan Blom" wrote:

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

--
Stefan Blom
Microsoft Word MVP



"Stefan Blom" wrote in message
...
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.

--
Stefan Blom
Microsoft Word MVP



"Edwin (Borinquen)" Edwin wrote in
message ...
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




.

  #6  
Old April 1st, 2010, 10:24 PM posted to microsoft.public.word.docmanagement
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default how can I perform a math funcion in word

Hi Edwin,

To see how to perform a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[Microsoft MVP - Word]


"Edwin (Borinquen)" Edwin wrote in message
...
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


  #7  
Old April 2nd, 2010, 06:00 AM posted to microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
 
Posts: 18,297
Default how can I perform a math funcion in word

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
Word MVP web site http://word.mvps.org



"macropod" wrote in message
...
Hi Pesach,

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


--
Cheers
macropod
[Microsoft MVP - Word]


"Pesach Shelnitz" pesach18(AT)hotmail.com wrote in message
...
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.

--
Hope this helps,
Pesach Shelnitz
My Web site: http://makeofficework.com "Stefan Blom" wrote:

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

--
Stefan Blom
Microsoft Word MVP



"Stefan Blom" wrote in message
...
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.

--
Stefan Blom
Microsoft Word MVP



"Edwin (Borinquen)" Edwin
wrote in message
...
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




.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.