excel 2007 running balance

[hallmark]

Think of it as a bank account

add the deposits, take away the costs = balance

100+100-50-60 = 90

Ta-da

Yes but you have to use brackets in correct places,,, as in

(100+100)-(50-60) = 90

[hallmark]

Yes but you have to use brackets in correct places,,, as in

(100+100)-(50+60) = 90

(Deposit+Deposit)-(Spend+Spend)=90

[hallmark]

    Posts: 939
    bodger sen. jun.
        View Profile Personal Message (Offline)

Re: excel 2007 running balance
« Reply #2 on: Today at 03:05:03 PM »

    Quote

A little more clarity

         A       B         C        D           E              F         G                     H
 1     date  deposit  date  product  quantity      cost     total                balance
 2               100                toy           5     x     10  =   50 =(E2xF2) =   50  formula =B2-G2
 3               100                bug          12    x      5   =  60         =   90 formula =(H2+B3)-(G2+G3)
 4                50                wig            2     x   100   =  200 =  60-
 5               150                toy            2    x      10  =  20   =  70

[hallmark]

Online hallmark

    -
    RootsChat Marquessate
    ******
    Posts: 6,158
        View Profile Personal Message (Online)

Re: excel 2007 running balance
« Reply #11 on: Today at 05:46:15 PM »

    Quote

    Posts: 939
    bodger sen. jun.
        View Profile Personal Message (Offline)

Re: excel 2007 running balance
« Reply #2 on: Today at 03:05:03 PM »

    Quote

A little more clarity

         A       B         C        D           E              F         G                     H
 1     date  deposit  date  product  quantity      cost     total                balance
 2               100                toy           5     x     10     =(E2xF2)       formula =B2-G2
 3               100                bug          12    x      5     =(E3xF3)       formula =(H2+B3)-(G2+G3)
 

[StevieSteve]

That last formula isn't right - you need to lose the G2 (it's already included in calculating H2)


(Which will then have the added bonus of being the same as I had already posted in the first reply on this thread)

[hallmark]

That last formula isn't right - you need to lose the G2 (it's already included in calculating H2)


(Which will then have the added bonus of being the same as I had already posted in the first reply on this thread)

Yes you are correct

         A       B         C        D           E              F         G                     H
 1     date  deposit  date  product  quantity      cost     total                balance
 2               100                toy           5     x     10     =(E2xF2)       formula =B2-G2
 3               100                bug          12    x      5     =(E3xF3)       formula =(H2+B3)-G3

don't have Excel...