Results 1 to 4 of 4

Acheive a a declining subtraction to 0 rather than a negative number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Acheive a a declining subtraction to 0 rather than a negative number

    Hi all,

    I'm not sure how to explain my problem, so I've attached a sample spreadsheet. I think that might be clearer than my explanation.

    What I'm trying to achieve is a declining subtraction to 0 rather than a negative number, as I've shown in row 25.
    Also in row 22 I would like the values to show 0 from the left until the last positive figure in row 25.
    In cell B21 I would like to show the figure carried over as shown in cell K22.


    Many thanks
    Attached Files Attached Files

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: 03-05-2014, 01:19 PM
  2. [SOLVED] Help with subtraction while ignoring a negative value in a cell.
    By ravi008 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2013, 03:38 PM
  3. [SOLVED] Iterate subtraction until just before it becomes negative
    By riehlncopower in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 05:39 PM
  4. Replies: 4
    Last Post: 03-04-2012, 12:21 PM
  5. 2003= negative number&2004= negative number How Do I Calculate gro
    By Jason in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2005, 02:06 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