functions

B

Bernard Liengme

And the question is?
Maybe the answer could be:
A1 =600000, B1=100000 (money received) and C1 =A1-B1 (balance of 50000)
best wishes
 
M

mahmoud

Bernard Liengme said:
And the question is?
Maybe the answer could be:
A1 =600000, B1=100000 (money received) and C1 =A1-B1 (balance of 50000)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


suppose in coloumn a there is a1 value 60000
coloumn b represent parametric value b1=100,b2=200.....etc
and c represent the balnce always
 
P

pinmaster

Hi,

Not sure if this will help but try this in C1:

=IF(B1="","",$A$1-SUM($B$1:B1))
copy down as far as needed

Regards!
Jean-Guy
 
Top