+ Reply to Thread
Results 1 to 5 of 5

automatically restart formulas when col reaches positve

  1. #1
    Registered User
    Join Date
    12-01-2015
    Location
    ballarat
    MS-Off Ver
    2013
    Posts
    85

    automatically restart formulas when col reaches positve

    Hello,
    I am trying to develop a project and hope someone can provide some assistance please.
    Basically I would like to know if there is a way automatically to have a set of formulas and calculations stop when a positive number is reached in column H and then the whole procedure commenced again from the start.
    Amounts are entered and with my calculations they are updated,sometimes adding,sometimes subtracting from the column. Once it goes to >0 I place that amount in a separate column and then start the process all over again.
    I have included my worksheet.
    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: automatically restart formulas when col reaches positve

    What do you mean start again?
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Registered User
    Join Date
    12-01-2015
    Location
    ballarat
    MS-Off Ver
    2013
    Posts
    85

    Re: automatically restart formulas when col reaches positve

    Hello,
    Thank you for response.Starting again means to start the process again from Row 2.

  4. #4
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: automatically restart formulas when col reaches positve

    Sorry, I left my brain at work today, but start what again?

  5. #5
    Registered User
    Join Date
    12-01-2015
    Location
    ballarat
    MS-Off Ver
    2013
    Posts
    85

    Re: automatically restart formulas when col reaches positve

    Hello,
    As I said Row 2 this is the starting point followed by row 3 and the formulas continue to follow as shown in the columns G,H,I ,and J

+ 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. Lookup on negative value to return yes and on positve value no
    By Colin Smit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2015, 07:49 AM
  2. [SOLVED] Sum two if both cells contains positve value
    By Petter120 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-12-2014, 08:37 AM
  3. [SOLVED] Look up a range of values in an array and sum them if they are positve
    By Brian Powell 66 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 03:00 PM
  4. Replies: 3
    Last Post: 09-02-2011, 06:55 AM
  5. [SOLVED] formula/function that prints only positve numbers
    By Kara Hoover in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-02-2006, 06:20 PM
  6. Return minimum POSITVE value from range
    By TheRobsterUK in forum Excel General
    Replies: 7
    Last Post: 09-27-2005, 10:05 AM
  7. calculate negative or positve difference in time
    By kpmoore in forum Excel General
    Replies: 2
    Last Post: 01-04-2005, 10: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