+ Reply to Thread
Results 1 to 2 of 2

transfer cell $ amount to other sheet month-to-month without overc

  1. #1
    Colin2u
    Guest

    transfer cell $ amount to other sheet month-to-month without overc

    I am trying to do a budget plan for an entire year going into the next. I am
    trying to have it transfer the savings ($ amout) of the current month to the
    next month and have the that saving be added to any possible savings of the
    next if it is to be. here is what i have in theary: If the item in cell "H30"
    is possitive but also greater than the item in cell "K42", show a savings and
    have it be transfered to the next month budget plan.
    is that a possible task?

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    For the current sheet, to show the amount that will be transferred,

    =if(and(h30>0,h30>k32),h30-k32,0)

    or, for the next sheet

    =IF(AND(Sheet1!H30>0,Sheet1!H30>Sheet1!K32),Sheet1!H30-Sheet1!K32,0)

    etc
    Last edited by Bryan Hessey; 07-27-2005 at 09:40 PM.

+ 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