+ Reply to Thread
Results 1 to 4 of 4

minus number from cell and result in specific cell and specific column

Hybrid View

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    Egypt
    MS-Off Ver
    Excel 2007
    Posts
    22

    minus number from cell and result in specific cell and specific column

    What is the formulas for these two questions

    First question

    What I want is like this

    I have number in cell (A1) = 100
    when I enter number in any cell of column(B) for example (B1)=10
    then in cell (C1) the result of (A1) - (B1) = (90)

    and if I add in cell (B2)=10
    then in cell (C1) the result of (A1) - (B1+B2) = 80 .accumulatively in cell (C1)

    and any number in column (B), the result will be (A1) minus any number in column(B) accumulated in (C1)

    <<<<<<<<<<<<<<<<<<<

    second question

    As above, but some thing is different which is

    I have number in cell (A1) = 100
    when I enter number at cell (B1) = 10
    then the result would be in the adjacent cell (C1) = (A1) - ( B1) = 90
    and If I enter a new number in cell (B2) = 10
    then the result would be in the adjacent cell (C2) = (A1) - (B1+B2) = 80
    and If I enter a new number in cell (B3) = 10
    then the result would be in the adjacent cell (C3) = (A1) - (B1+B2+B3) = 70
    and so on ..

    I want the result to be add automatically to adjacent cell in column (C)
    Last edited by voltaire101; 01-21-2009 at 06:24 PM. Reason: correction

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    1. In cell C1, put the formula:
    =A1-(SUM(B:B))

    2. In cell C1 put this formula and then copy it down the C column:
    =IF(ISNUMBER(B1),$A$1-(SUM($B$1:B1)),"")

    Enter that carefully, copying it down WILL change formula in each cell if entered correctly.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949
    =IF($B1="","",$A$1-SUM($B$1:$B1))
    enter that in C1

    You can drag it down as many rows as you like, it'll adapt to the row it's on.

    I can't tell what's different between your two questions.

    EDIT:
    Oh I didn't see that the first one always totalled in C1
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  4. #4
    Registered User
    Join Date
    01-16-2009
    Location
    Texas
    MS-Off Ver
    2013, 2015, 2016
    Posts
    43
    #1 =if(isblank($b$1),$a$1,sum(a1-(b:b)))
    #2 =if(isblank(b1),$a$1,sum(a1-($b$1:$b1)))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1