how to get a formula to stay as 0

A

anier614

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.
 
B

Bernard Liengme

=if(B1>0,A1-B1,0) ' to display zero
or
=if(B1>0,A1-B1,"") ' to display nothing
or
=(A1-B1)*(B1>0) also displays zero
best wishes
 
T

T. Valko

Try this:

=IF(B2="",0,A1-B2)

It might look better if you just left the cell balnk:

=IF(B2="","",A1-B2)
 
Top