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: Edwin (Borinquen) Edwin on 1 Apr 2010 14:20 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: Stefan Blom on 1 Apr 2010 14:57 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
From: Stefan Blom on 1 Apr 2010 15:07 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 > >
From: Pesach Shelnitz on 1 Apr 2010 17:13 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 > > > > > > > . >
From: macropod on 1 Apr 2010 17:23
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 >> > >> > >> >> >> . >> |