Math Function

[Guest]

Can any one help me with a problem? What I have is 5 cell A5 to E5 in a row
with 500 in each one, then I have column with 7 cell B7 to B13 with different
numbers in it, then have two cell D7 to D8 with drop list in each one for
cell in roll A5 to E5. Now when I put numbers in column B7 to B13 it
subtracts from one drop list of which cell I pick to take away from D7 of
500, ? is how do you get it to subtract from cell B8 when B7 gets to zero? If
I had 100 in each cell from B7 to B13 thats 700 , B7 has 500 and B8 has 500,
I dont what D7 to show -200 want it to pick up from B8. This make any sense?

 

[johncassell]

try this -

cell A1 = 500, B1 = 500, C1 = 500, D1 = 500, E1 = 500
cell B7 = 100, B8 = 100, B9 = 100, B10 = 100, B11 = 100

Cell D7 contains the formula =IF(SUM(B7:B13)>A5,0,A5-SUM(B7:B13))
Cell D8 contains the formula =IF(SUM(B7:B13)<A5,A5,A5-SUM(B7:B13)+A5)

The result will be cell D7 = 0, cell D8 = 300.

Is this what you were after?

John

 

[Guest]

Hope so! Will try it later on.
Thanks,