=if(B10,A1-B1,0) ' to display zero
or
=if(B10,A1-B1,"") ' to display nothing
or
=(A1-B1)*(B10) also displays zero
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"anier614" wrote in message
...
i have a sheet where a put bills that have been sent out when i recieve
payment. i have another cell that tells the differnce between received and
original bill.
like this
=a1-b2
but when payment is not received i get a1 amount all the way down on my
sheet. so how can i get my cell to stay 0 if payment is not recieved.

thank you, i hope i'm not being too confusing.