#1   Report Post  
Posted to microsoft.public.excel.misc
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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Math Function


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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 181
Default Math Function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with math Function wytedragn Excel Worksheet Functions 2 June 29th 06 11:51 PM
IF function to blank without getting #value in sum function Brad Stevenson Excel Worksheet Functions 5 May 26th 05 11:26 AM
Date & Time mully New Users to Excel 4 May 23rd 05 12:56 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 03:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"