+ Reply to Thread
Results 1 to 2 of 2

I need help with a financial balance

  1. #1
    Registered User
    Join Date
    03-14-2019
    Location
    Barcelona
    MS-Off Ver
    2019
    Posts
    1

    Question I need help with a financial balance

    Hi,
    I want to make a financial balance [=SUM(earnings)-SUM(expenses)] with the following conditions:
    1. When it goes below 0 shows a 0 instead of a negative result.
    (e.g: Earnings=10; Expenses=15; Real balance=-5; Objective cell=0)

    This first part it's easy, I have accomplished this with the following formula:
    Objective cell=IF(SUM(earnings)-SUM(expenses)>0;SUM(earnings)-SUM(expenses);SUM(earnings)-SUM(expenses)+ABS(Real balance))

    2. If now I get a new earning, it adds to my objective cell, and not to the real balance.
    (e.g:
    Earnings=10
    New earning=10
    Total earnings=20
    Expenses=15
    Real balance=5
    Objective cell=5 (so it shows the previous balance (=0)+new earnings=5). The problem is that the objective cell will only be 0 when the real balance it's negative and, when the new earning is introduced, the real balance stops being 0 so the difference won't be added.

    I am stuck here, I hope someone can help me.

    Thanks for reading!

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

    Re: I need help with a financial balance

    How about ...

    =max(0, sum(earnings) - sum(expenses))
    Entia non sunt multiplicanda sine necessitate

+ 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. Replies: 2
    Last Post: 09-28-2015, 02:05 PM
  2. Formula for solving the financial balance sheet to make it tally
    By perpectuals in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-24-2015, 02:36 AM
  3. Replies: 1
    Last Post: 03-04-2012, 02:37 AM
  4. Replies: 4
    Last Post: 01-02-2011, 04:30 PM
  5. Excel 2007 : Balance Comparisons – Financial Year
    By mick2 in forum Excel General
    Replies: 0
    Last Post: 06-29-2010, 07:42 PM
  6. I want Financial statements linked to Trial Balance
    By omaniboy in forum Excel General
    Replies: 3
    Last Post: 05-11-2009, 05:14 AM

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