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

    Tricky Stuff! (Excel 2000)

    I don't know a huge amount about the inner workings of Excel.
    I would like to automate the creation of a document that shows a list of loan amounts and our corresponding fee.
    I would like to know if it is possible to have some sort of form where I could fill in e.g.
    The First 500,000 fee is 0.2%
    for the next 250,000 fee is 0.175%

    and so on, which would then create a sheet showing every intermediate loan amount in say, 10,000 steps along with our fee.

    I hope I am making sense. Could someone let me know if this is possible and maybe point me in a direction please.

    Thanks,
    Emily.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tricky Stuff! (Excel 2000)

    Sure, check out the attached file!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: Tricky Stuff! (Excel 2000)

    Thanks Jan,
    That's very helpful.
    I can make a start now.

    Emily

Posting Permissions

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