+ Reply to Thread
Results 1 to 5 of 5

Budget reduction column

  1. #1
    Registered User
    Join Date
    09-22-2022
    Location
    Chicago
    MS-Off Ver
    2019
    Posts
    5

    Question Budget reduction column

    I have a spreadsheet that I need help thinking through a formula on. Thank you in advance.

    I have a single sheet that has 3 different departments all with different budget totals. I like to keep the column blank until an amount is entered, and this formula works perfectly for my needs of keeping a running remaining budget total:

    =IF(OR(ISBLANK(F4),ISBLANK(F4)), "", G3-F4)

    The issue is that when a different department spends money, then it creates a blank line in the other two departments, so now it returns an error because the line immediately above is now blank. I can not refer to the original budget amount because then it's not a running total of my remaining budget for that department. I need it to refer to the remaining total from the last line that had an expenditure.

    I hope this makes sense.

    Thanks.

  2. #2
    Registered User
    Join Date
    09-22-2022
    Location
    Chicago
    MS-Off Ver
    2019
    Posts
    5

    Re: Budget reduction column

    Visual of what I'm wanting to do and how it's not working.

    Attachment 838618

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Budget reduction column

    Try this:

    =IF(F4="","",G$3-SUM(F$3:F4))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Registered User
    Join Date
    09-22-2022
    Location
    Chicago
    MS-Off Ver
    2019
    Posts
    5

    Re: Budget reduction column

    As expected, it works perfectly. Thank you, AliGW!


    PS. It is giving me a formula inconsistency error every time it calculates a reduction, but I will just ignore errors if that's a complicated fix.
    Last edited by brvheart; 08-04-2023 at 01:46 PM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Budget reduction column

    Don't know what you mean - please attach a sample workbook to illustrate the problem.

+ 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] scaling reduction of a price based on GP Value in another column
    By Steve1977 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-25-2023, 09:56 AM
  2. [SOLVED] Cut and Paste Values From Monthly Budget to Annual Budget Setup
    By BillySpivy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-10-2022, 03:02 PM
  3. [SOLVED] VBA to change Budget Amount for Annual Budget Setup sheet
    By BillySpivy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2021, 10:30 AM
  4. Replies: 2
    Last Post: 03-15-2017, 03:14 AM
  5. Nested IF statement to show under budget, within a % of budget, over budget
    By clafleur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2015, 10:36 AM
  6. [SOLVED] Sorting 2 columns and a 10% reduction value to a separate column
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2014, 10:03 AM
  7. Budget and Debt Reduction Spreadsheet
    By gapeach39 in forum Excel General
    Replies: 1
    Last Post: 03-25-2013, 11:40 AM

Tags for this Thread

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