Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get a formula to stay as 0
=IF(B2="",0,A1-B2)
-- Gary''s Student - gsnu200749 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting a row to stay on top | New Users to Excel | |||
formatting doesn't stay | Excel Discussion (Misc queries) | |||
formula to stay fixed on two columns as you add more columns | Excel Discussion (Misc queries) | |||
How do I get my formula to stay the same | New Users to Excel | |||
Autofit does not stay on. | Excel Discussion (Misc queries) |