+ Reply to Thread
Results 1 to 3 of 3

Using Mod function to double a rent every 5 years

  1. #1
    Registered User
    Join Date
    08-16-2011
    Location
    Leeds
    MS-Off Ver
    Excel 2007
    Posts
    33

    Using Mod function to double a rent every 5 years

    Hi,

    I wanted to seek some help to create one formula in cashflow to double the rent every 5 years. The desire cashflow is hardcoded but needed some help to create on formula that can do this for me.

    Thanks

    Stephen
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Using Mod function to double a rent every 5 years

    Formula for G11 then fill right

    =IF(MOD(YEAR(G5)-YEAR($F5),5)=0,2,1)*F11
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    08-16-2011
    Location
    Leeds
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Using Mod function to double a rent every 5 years

    thank you very much

+ 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. Need to Find escalation % on Series of Rent data for years in horizontal form
    By Ganapathyraman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2023, 09:01 AM
  2. Calculate rent with 15% increase every 3 years
    By dilshandil in forum Excel General
    Replies: 3
    Last Post: 11-29-2020, 04:15 PM
  3. Replies: 7
    Last Post: 09-18-2019, 09:07 AM
  4. Replies: 6
    Last Post: 09-17-2019, 07:04 AM
  5. How to calculate rent over a number of years
    By jennifer Daley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2013, 10:22 PM
  6. Replies: 2
    Last Post: 09-21-2012, 03:32 AM
  7. Replies: 6
    Last Post: 06-07-2010, 04:57 AM

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