functions

  • Thread starter Thread starter mahmoud
  • Start date Start date
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 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
 
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
 
Back
Top