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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|