+ Reply to Thread
Results 1 to 6 of 6

apply inflation at annivsery period to prior value

  1. #1
    Registered User
    Join Date
    05-23-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    3

    apply inflation at annivsery period to prior value

    Hi Forum,

    Hopefully you can help.
    I'm trying to work out how to create a forumla that applies inflation based on a a dynamic anniversary period.
    for example I have an amount in month 1 of 10,000 and the annivsary is in 36 months time, i want the forumla to look at the date in the row, check if its 36 months from the start date and then should add say 5% inflation - so 10,500, then again in 36 months time it needs to add another 5%, but to the previous amount of 10,500.

    attached might help to explain better.. this is driving me mad.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,437

    Re: apply inflation at annivsery period to prior value

    Welcome to the forum.

    Please add a column to your workbook showing a few expected results (e.g. the first 36 months and a couple of anniversary values after that). Do this MANUALLY, please. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-23-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    3

    Re: apply inflation at annivsery period to prior value

    attached with expected result, I had a go with a forumla I found on previous posts and it kind of works at the anniversary date,but can't work out why its produces error values.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,141

    Re: apply inflation at annivsery period to prior value

    Maybe:

    =IF(ROWS(B$5:B5)=1,$F$2,IF(MOD((ROWS(B$5:B5)-1),36)=0,(1+$E$2)*MAX($F$2,MAX(B$4:B4)),0))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  5. #5
    Registered User
    Join Date
    05-23-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    3

    Re: apply inflation at annivsery period to prior value

    superb Glenn, thanks a million! much appraciated.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,141

    Re: apply inflation at annivsery period to prior value

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ 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. [SOLVED] How to Populate Inflation Accross Cost types & Apply Inflation Rate
    By Johnyam54 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-15-2021, 12:46 PM
  2. Replies: 2
    Last Post: 09-02-2020, 10:16 AM
  3. Macro to apply USD inflation rates to values in a dynamic range
    By mgm5338 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2018, 01:29 PM
  4. Apply filters prior to printing
    By DAULT in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 12-08-2017, 10:36 AM
  5. difference from prior period in pivot tables
    By stephme55 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2016, 03:32 PM
  6. Replies: 1
    Last Post: 02-26-2015, 06:12 PM
  7. Replies: 4
    Last Post: 08-15-2012, 12:27 PM

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