+ Reply to Thread
Results 1 to 3 of 3

Formulas to extend monthly budget figures

  1. #1
    Registered User
    Join Date
    12-11-2019
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Formulas to extend monthly budget figures

    I'm new to using Excel and have a simple chart I need help with.
    it's shown below:


    E F G (etc.....for 52 weeks!)
    1 YEAR TO DATE BUDGET: 3508.47 7106.94 10525.41
    2
    3 RECEIVED YEAR TO DATE: 4167.64 6012.64 8678.64
    4
    5 WEEKLY OFFERING BUDGETED: 3508.47 3508.47 3508.47
    6
    7 RECEIVED LAST WEEK: 4167.64 1845 2666

    Line 5 will remain 3508.64 for the duration of the report.
    I'll input the amount into line 7 every week.

    I need to have E1 added to 5E & put in F1.
    and 3E added to 7E and the total be put into F2

    How can I make that happen?
    Thank you for your help!!!
    Last edited by 6StringJazzer; 12-11-2019 at 03:17 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: NEED HELP, I don't know enough to give a good description.

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles.

    "NEED HELP, I don't know enough to give a good description." is not a good title.

    I have updated it for you this time because you are a new member. --6StringJazzer
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,691

    Re: Formulas to extend monthly budget figures

    In F1 put
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy to the right

    in F2 put
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy to the right

+ 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] Ignore blank cell to give give non zero result
    By rehan0129 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2018, 12:04 PM
  2. [SOLVED] Drop List with a description but once chosen description disappear
    By dezspert22 in forum Excel General
    Replies: 22
    Last Post: 12-19-2016, 05:24 PM
  3. [SOLVED] Which formaula give the actual result in description column
    By Imran368 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2016, 02:53 PM
  4. [SOLVED] Lower than -10% give 1, then give 2.
    By tsakta13ole in forum Excel General
    Replies: 5
    Last Post: 06-07-2016, 02:15 PM
  5. [SOLVED] why give me error #VALUE ... i need to give me the numbers from small to big
    By mena in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-22-2015, 10:11 AM
  6. Replies: 2
    Last Post: 07-03-2015, 04:08 AM
  7. Give RELEVANT responses to questions. DO NOT give usless list
    By pmartin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2006, 02:00 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