how to get a formula to stay as 0

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date and amount of last payment 3
Calculating Days Late 1
Formula not calculating correctly 4
Formula question 1
Problem w/ cell reference 2
AR Aging Report Design Issue 2
Conditional function row formatting based on columns values being 2
Slight change now macro error 2

Top