Results 1 to 6 of 6

apply inflation at annivsery period to prior value

Threaded View

  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

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