Posted: 8/22/2006 5:23:18 PM EDT
| How do you make a formula cell not show an error? For example, I have a cell with the formula =(c3/b3) but there is nothing in c3 and b3 yet. I seem to remember that I knew how do do this once, but I can't remember now. |
. Right now b3 and c3 would be blank and d3 would be the formula =(c3/b3) and has an error.
(Easier than going back and forth) =if(or(c3=0,b3=0),0,c3/b3) The IF command is your friend. Use it often, use it well. |
D3 gets
if you want to make it cool. |
ISBLANK isn't a good way to do this. It doesn't trap the error when the cell it refers to contains a zero, and if the cell it refers to contains ANYTHING, including a formula (even a formula whose result is a blank) then it will return "false". In calculations (most of the time) a blank or null is treated as a zero. IF you need to keep the cell blank until the calculation is properly completed, you can use something like =if(or(b3=0, c3=0),"",c3/b3) The quote marks are a double quote followed by another double quote, with no spaces or anything between. |
What I actually ended up with was