| 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. |
| 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) | |||
Threaded Mode
