how can I perform a math funcion in word
in [Document Management]
|
Prev: Mail merge recipient dialog box
Next: created encryped.docx in Word 2007, edited in 2010, now cannot open in 2007
From: macropod on 1 Apr 2010 17:24 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/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "Edwin (Borinquen)" <Edwin (Borinquen)@discussions.microsoft.com> wrote in message news:F86BCA79-6A1C-4DD2-AF33-C82E70C520BB(a)microsoft.com... > 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
From: Graham Mayor on 2 Apr 2010 01:00
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" <macropod(a)invalid.invalid> wrote in message news:%23Z1zPGe0KHA.3652(a)TK2MSFTNGP04.phx.gbl... > 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 > news:F479D8FB-2E01-4491-B8F4-D824DE33990F(a)microsoft.com... >> 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" <StefanBlom(a)discussions.microsoft.com> wrote in message >>> news:%23MKgvyc0KHA.3500(a)TK2MSFTNGP02.phx.gbl... >>> > 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 (Borinquen)@discussions.microsoft.com> >>> > wrote in message >>> > news:F86BCA79-6A1C-4DD2-AF33-C82E70C520BB(a)microsoft.com... >>> >> 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 >>> > >>> > >>> >>> >>> . >>> |