how to get a formula to stay as 0
 

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.

how to get a formula to stay as 0
 

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

how to get a formula to stay as 0
 

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

--
Gary''s Student - gsnu200749

how to get a formula to stay as 0
 

Try this:

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

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

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

--
Biff
Microsoft Excel MVP


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

how to get a formula to stay as 0
 

thanks a lot, your responses were very helpfull

"anier614" wrote:

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.