+ Reply to Thread
Results 1 to 6 of 6

carrying forward

  1. #1
    Registered User
    Join Date
    10-22-2007
    Posts
    16

    Unhappy carrying forward

    Hi,

    I am trying to create a function that would do the following:
    you have a maximum claim that you can expense per year(10; column 1), and you have your expenses (column 2). However, if your expenses are greater that the maximum expense for the year, you can carry it forward to the next year and claim in in following years.
    Basically I want to set up a function that replicate the claimed column
    Hope this make sense

    Many thanks for your help

    Maximum Expense Expense Claimed
    10....................... 7 .............7
    10....................... 9 .............9
    10 ...................... 12............10
    10 ....................... 13............10
    10.......................... 2............7
    10..........................11............10
    10...........................8............9
    Last edited by pilou; 08-30-2009 at 12:24 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: carrying forward

    C2 and down: =MIN(A2, SUM(B$1:B2) - SUM(C$1:C1))
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-22-2007
    Posts
    16

    Smile Re: carrying forward

    thanks so much!!!!
    i did spend a few hours on it trying to code it while a simple function does the job

    thanks again that really help

  4. #4
    Registered User
    Join Date
    10-22-2007
    Posts
    16

    Re: carrying forward

    And any idea for C1?

  5. #5
    Registered User
    Join Date
    10-22-2007
    Posts
    16

    Re: carrying forward

    sorry stupid question, i just sorted it out

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: carrying forward

    And any idea for C1?
    Header row.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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