functions

[mahmoud]

a=constant suppose 600000
b is reciept
c is the balance

 

[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

 

[David Biddulph]

If you are asking how to add A1 and B1, the formula is =A1+B1.

 

[Stan Brown]

Sun, 25 Nov 2007 05:30:01 -0800 from mahmoud

a=constant suppose 600000
b is reciept
c is the balance

And what is your question about functions?

 

[mahmoud]

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

 

[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