Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 -- johncassell ------------------------------------------------------------------------ johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016 View this thread: http://www.excelforum.com/showthread...hreadid=565765 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hope so! Will try it later on.
Thanks, "johncassell" wrote: 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 -- johncassell ------------------------------------------------------------------------ johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016 View this thread: http://www.excelforum.com/showthread...hreadid=565765 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with math Function | Excel Worksheet Functions | |||
IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |