+ Reply to Thread
Results 1 to 8 of 8

Subtract formula and Text to numbers in MS Word Doc

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Subtract formula and Text to numbers in MS Word Doc

    Dear Experts,

    Please find here attached a sample MS Word Document, Is there any way where we can use the automatic outcomes for "Total Deductions" value in highlighted cell with yellow color (Total Payable - Net Payable), Paid Sum (In Word) from Net Payable Amount and all the value fields (from Basic Salary till Net Payable) to be separate with commas.

    Request to you please do help me.

    I hope i have explained about the expected outcomes. Please get back for further clarifications.

    Sincerely,

    Neilesh
    Attached Files Attached Files

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Subtract formula and Text to numbers in MS Word Doc

    That's as simple as using a formula field coded as:
    {QUOTE{={MERGEFIELD TOTAL_PAYABLE}-{MERGEFIELD NET_PAY}}}
    or:
    {QUOTE{=«TOTAL_PAYABLE»-«NET_PAY»}}

    Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either).
    Last edited by macropod; 05-18-2020 at 12:03 AM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Re: Subtract formula and Text to numbers in MS Word Doc

    Dear Expert Macropod, Thank you so much for your precious support. Dear Expert, I have tried to put the provided formula but could not able to achieve the results. Since i am not a very well versed with MS Word formulae part, so would like to request to you can you please do provide the formula in attached sample workbook and provide me.

    Thank you once again for your valuable support.

    Sincerely,

    Neilesh

  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Subtract formula and Text to numbers in MS Word Doc

    It is very simple to do...
    1. Insert your two mergefields, with a minus sign (hyphen) between them:
    «TOTAL_PAYABLE»-«NET_PAY»
    2. Select both of those fields and press Ctrl-F9 to create another field around them, and insert an equals sign at the start:
    {=«TOTAL_PAYABLE»-«NET_PAY» }
    3. Select the outer field you created in the last step,and press Ctrl-F9 to create another field around it, then type QUOTE at the start:
    {QUOTE{=«TOTAL_PAYABLE»-«NET_PAY»}}
    Done.

  5. #5
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Re: Subtract formula and Text to numbers in MS Word Doc

    Thank you so much dear expert. It worked perfectly. Is there any way to convert merge field amount into text. for eg. if merge field "«NET_PAY»" amount is 50 then i can be show the value as well in text format "Rupees Fifty only". Request to you please do let me know.

    Sincerely,

    Neilesh

  6. #6
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Subtract formula and Text to numbers in MS Word Doc

    That can get very complicated. See: https://www.msofficeforums.com/mail-...mber-text.html

  7. #7
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Re: Subtract formula and Text to numbers in MS Word Doc

    Thank you so much dear Expert for your precious support.

  8. #8
    Registered User
    Join Date
    07-08-2020
    Location
    Ukraine, Kiev
    MS-Off Ver
    Microsoft Office 2010 (64-bit)
    Posts
    15

    Re: Subtract formula and Text to numbers in MS Word Doc

    Great, I found a subject with a similar question, thank you very much for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to subtract two numbers in cell J6
    By Mr.Castle in forum Excel General
    Replies: 7
    Last Post: 02-12-2019, 01:03 PM
  2. Formula for a smaller value than the sum subtract two numbers
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2014, 03:42 PM
  3. [SOLVED] Subtract Range Of Numbers using a Formula
    By Josh Davis in forum Excel General
    Replies: 2
    Last Post: 06-25-2014, 10:22 AM
  4. Replies: 4
    Last Post: 12-02-2013, 03:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1