+ Reply to Thread
Results 1 to 6 of 6

change in value by exponent date

  1. #1
    Registered User
    Join Date
    09-25-2014
    Location
    virginia
    MS-Off Ver
    2010
    Posts
    3

    change in value by exponent date

    so I am trying to create an annual schedule where a fee is increase by a percentage on its anniversary date.

    ROUND($A$8*((1+$A$9)^(YEAR(B14)-YEAR($A$6))),2)

    This formula is giving me the initial correct balance, but it does not increase on the anniversary month in my 12 rows J-D. I have tried changing the "Year" formula to a "date" one with no success. Help!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: change in value by exponent date

    Please upload the workbook and manually add the results you expect. Also say whether you are compounding the fee % increase or just simple increase.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-25-2014
    Location
    virginia
    MS-Off Ver
    2010
    Posts
    3

    Re: change in value by exponent date

    The fee just increases once a year on the contract anniversary date, and then stays at that rate until the next anniversary. Thank you,
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-27-2013
    Location
    Boulder, CO
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: change in value by exponent date

    Try what was done here:

    http://www.excelforum.com/excel-form...hire-date.html

    Hope this helps.

    -Z

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: change in value by exponent date

    Hi,

    See attached Sheet1 for the general approach. Adapt to your layout as necessary
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-25-2014
    Location
    virginia
    MS-Off Ver
    2010
    Posts
    3

    Re: change in value by exponent date

    Thanks! that worked!

+ 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. Keeping the exponent at a fix value in Excel
    By WAYNEL in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 11:45 AM
  2. Keeping the exponent at a fix value in Excel
    By WAYNEL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2006, 11:45 AM
  3. [SOLVED] Keeping the exponent at a fix value in Excel
    By WayneL in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-09-2006, 04:30 AM
  4. Change Excel Exponent Default Setting
    By Scull in forum Excel General
    Replies: 7
    Last Post: 01-13-2005, 05:06 PM
  5. Turning off the Exponent Function
    By Jeffn21 in forum Excel General
    Replies: 0
    Last Post: 01-10-2005, 12:04 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