Results 1 to 4 of 4

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

Threaded View

voltaire101 minus number from cell and... 01-20-2009, 11:34 PM
JBeaucaire 1. In cell C1, put the... 01-20-2009, 11:42 PM
mewingkitty =IF($B1="","",$A$1-SUM($B$1:$B... 01-20-2009, 11:42 PM
melegaunt #1 ... 01-21-2009, 05:37 AM
  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

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