+ Reply to Thread
Results 1 to 3 of 3

Amortization Table

  1. #1
    Registered User
    Join Date
    01-16-2017
    Location
    Cape Town, South Africa
    MS-Off Ver
    2016
    Posts
    51

    Amortization Table

    Hi Guys

    I'm trying to come up with a more efficient way of formatting my amortization table (attached).

    My goal is to make Cell B6 dynamic - when input any number from 0-30 I would like it to return "Years" and then anything after that from 31-360 to return "Months". I would also like my PERIOD column A to adjust accordingly (i.e. to return 30 cells if "Years" and 31 cells if "Months".

    Currently I have done this and it works, however it is rather convoluted and I would like to speed up the process - any help would be greatly appreciated.

    I also currently have 4 rule applied to B6 - any way I can reduce this to 2? I would also like to find a way to accomplish this without having my data validation cell E3?

    Regards

    SilverBullet
    Attached Files Attached Files

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,668

    Re: Amortization Table

    Hi there,

    See if the attached workbook does what you need.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,668

    Re: Amortization Table

    Hi again,

    Many thanks for the Reputation increase - much appreciated

    Regards,

    Greg M

+ 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. using if function in an amortization table
    By rdcall in forum Excel General
    Replies: 12
    Last Post: 02-01-2015, 10:57 AM
  2. Does anyone have a good amortization table?
    By TomRet in forum Excel General
    Replies: 3
    Last Post: 04-02-2014, 04:42 PM
  3. Amortization Table related to IF statement and some
    By sumrandumgi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2013, 09:09 PM
  4. Question about VBA amortization table
    By rollintide89 in forum Excel General
    Replies: 1
    Last Post: 11-08-2011, 01:59 AM
  5. IRR without amortization table?
    By excelnewbie10 in forum Excel General
    Replies: 0
    Last Post: 03-22-2010, 01:13 PM
  6. Amortization Table help
    By ptpair in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2009, 09:38 PM
  7. unorthadox Amortization table
    By stewlevin in forum ExcelTip.com Feedback / Comments / Suggestions
    Replies: 1
    Last Post: 10-29-2007, 06:17 PM

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