Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Location
    Kent, UK
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Interest Calculation (Excel 2k)

    Hello everyone
    Attached is a spreadsheet containing an interest calculation.
    It shows the interest figure and the interest as calculated on a calculator.
    The figures are different because of some sort of left over data as far as I can tell.
    How do I make the figures match up (ie how to I clear out the latent data)

    Thanks in advance,
    Emily

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Interest Calculation (Excel 2k)

    The calculator version uses a rounded figure for the value in cell F10, you can replicate this by using:

    <big><code>=ROUND((A5*D5)/F5,2)</code></big>

  3. #3
    Star Lounger
    Join Date
    Oct 2003
    Location
    Kent, UK
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interest Calculation (Excel 2k)

    Thanks for that Tony.

  4. #4
    Star Lounger
    Join Date
    Oct 2003
    Location
    Kent, UK
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interest Calculation (Excel 2k)

    Don't know what I was thinking about harping on about latent data
    <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interest Calculation (Excel 2k)

    That's OK, neither do we. <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>
    Legare Coleman

Posting Permissions

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