Hello everyone

This is a 2 step question in microsoft excel:

I would like to be able to take a cell with number 50 hrs which will go down anywhere to 0 while another cell will increase the difference between that 50 and 0.

Part 1:

Example: cell A1=50 cell A2=0 cell A3=0

now cell A1=45 cell A2=5 therefore still = 50 cell A3=5

Cell A1=32 cell A2=18 therefore still =50 cell A3=18

Cell A1=0 cell A2=50 cell A3=50

Now the next thing I need is another cell that would keep adding this A2 hrs that would keep accumulating even though these 2 values in A1 and A2 will keep going up and down anywhere between 0 and 50.

Part 2:

So here goes my example:

Example: cell A1=50 cell A2=0 cell A3=0

now cell A1=45 cell A2=5 therefore still = 50 ...cell A3=5

Cell A1=32 cell A2=18 therefore still =50 ...cell A3=18

Cell A1=0 cell A2=50 ...cell A3=50

Cell A1=50 cell A2=0 ...cell A3=50

Cell A1=36 cell A2=14 ...cell A3=(50+14)=64 therefore Cell A3 keep accumulating all the time whenever cell A2 increases

Cell A1=15 cell A2=35 ...cell A3 =(64+35)=99

Cell A1=7 cell A2=43 ...cell A3=(99+43)=142

This will keep going on and on and on.....therefore cell A3 will keep increasing.

Is there a way to do this formula work?

Thanks very much for any help with this.

Cell A1=50 cell A2=0 ...cell A3=98

Open in new window

impact-worksheet-v2.xlsm