Thread: Math Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Math Function

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?