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

"mahmoud" wrote:

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