Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Excel >> Word (WinNT4/Word97)

    I have an Excel spreadsheet that contains the following link/calculation (it calculates the AER on a gross interest rate based on two interest payments a year) and I need to produce the same result in a Word document:

    ROUND(((1+(<font color=red>'O:commonrates[BASERATE.XLS]BASERATE'!$D$13</font color=red>)/200)^2-1)*100,2)

    I've managed to work out how to get the link (in red) in a Word bookmark and field, but could someone tell me how to put in the calculation around it in Word-speak, please? I've drawn a blank so far!
    Beryl M


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Excel >> Word (WinNT4/Word97)

    In the Word document, press Ctrl+F9. This inserts field brackets { } (you shouldn't type those brackets yourself, they won't work). Between the brackets, type
    <code>
    =ROUND(((1+(ZZZ)/200)^2-1)*100,2)
    </code>
    Replace the ZZZ with the linked Excel value (it must be pasted as text or HTML, not as a picture or as an Excel object), then press F9 to toggle the field codes off and to recalculate.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Excel >> Word (WinNT4/Word97)

    In other words, the calculation is exactly the same as the Excel version!

    Which makes me wonder why it didn't work when I had it like that ... I shall have to go back and check it minutely, there must be a typo in there somewhere.
    Beryl M


  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Excel >> Word (WinNT4/Word97)

    It might be easier to put the formula in Excel, and link to the cell containing the formula.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Excel >> Word (WinNT4/Word97)

    True, but I don't own the original XL spreadsheet and if it was in a separate one I couldn't guarantee it would never be removed!

    Don't worry, I'll get the Word version sorted!
    Beryl M


  6. #6
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Tallahassee, Florida, USA
    Posts
    901
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel >> Word (WinNT4/Word97)

    Hi Beryl. Word doesn't like your absolute indicators. It's cell designations must be expressed in a simple format, such as B13 and not $B$13.
    Karen

  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Excel >> Word (WinNT4/Word97)

    Hi Karen, yes, I'd noticed that - in fact it doesn't like B13 either, it insisted on R13C2!

    Edited to correct name - obviously too early in the morning for me!
    Beryl M


Posting Permissions

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