+ 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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,673

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,673

    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