+ Reply to Thread
Results 1 to 4 of 4

MS Word 365 Formula and Text Box

  1. #1
    Forum Contributor
    Join Date
    08-29-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    101

    MS Word 365 Formula and Text Box

    Hi, I wanted to add a text box to my word document for the year and a button to refresh the values so after the year is input into the textbox, then based on the year input, I want the value of several inventory items to update by calculating the their base value x3% per year starting at the year 2000, or -3% per year below 2K. The formula part is not so important, I can figure that out on my own later, I just need to know how to get started. I know this is normally an Excel job, but believe me, this is a Word document with only a small section displaying these numbers. This would be so easy in Excel, but with Word, it's my first attempt doing something like this. I literally stuck right from the start without a clue how to proceed. I'm guessing the "Formula" function, but I really don't know...
    Last edited by Taemex; 11-05-2020 at 02:33 AM.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,402

    Re: MS Word 365 Formula and Text Box

    You can do calculations in a Word table. Have a look here: https://support.microsoft.com/en-gb/...d-b2cb2c4f3e27
    As noted on that page, but perhaps not stressed enough, the formulae answers will only update when you refresh the fields - so your button to refresh would probably just need to do that.

    I don't know if it's possible to put a table into a text box - I've never tried - but you could just use a table instead of a text box and change its wrap options if you want it to be embedded in other text somehow.
    Regards,
    Aardigspook

    Recently moved house, internationally, during COVID (!) so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    08-29-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    101

    Re: MS Word 365 Formula and Text Box

    Unfortunately, it seems the formula I need from Excel are not present in Word, ex:
    Please Login or Register  to view this content.
    See attachment. It is an Excel example of what I need in Word. My Word Doc is pw protected, yet I'll somehow need a single cell or text box to be unprotected, and the cells to calculate the formula of annual compound interest. I guess I'll either need a Micro, or will have to skip this.
    Attached Files Attached Files

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

    Re: MS Word 365 Formula and Text Box

    To see how to do this and a wide range of other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
    https://www.msofficeforums.com/word/...-tutorial.html
    or:
    http://www.gmayor.com/downloads.htm#Third_party
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. [SOLVED] Subtract formula and Text to numbers in MS Word Doc
    By Neilesh Kumar in forum Word Formatting & General
    Replies: 7
    Last Post: 07-16-2020, 02:23 AM
  2. [SOLVED] How can I use the word Max as text in a formula?
    By SLIDE1 in forum Excel General
    Replies: 5
    Last Post: 11-04-2016, 09:56 PM
  3. Excel Formula to separate Word in a Text
    By su2009 in forum Excel General
    Replies: 2
    Last Post: 11-30-2015, 08:01 AM
  4. [SOLVED] changing text from word into a formula
    By ammartino44 in forum Excel General
    Replies: 5
    Last Post: 09-21-2015, 01:25 PM
  5. [SOLVED] Formula to pull first word out of string of text
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-24-2013, 05:24 AM
  6. [SOLVED] Formula to return a word from string of text
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-28-2013, 05:17 AM
  7. Number to text a word formula
    By joesport5 in forum Excel General
    Replies: 2
    Last Post: 03-18-2010, 11:25 AM

Tags for this Thread

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