G Guest Oct 25, 2006 #1 If the cell on which a formula is based is 0 or empty, I want the result that is shown to be blank. How do I build that into the formula?
If the cell on which a formula is based is 0 or empty, I want the result that is shown to be blank. How do I build that into the formula?
G Guest Oct 25, 2006 #3 That almost does the trick. Here is the formula I am working with: =(c4-b4)+1 If there is nothing in b4, how do I make the "if" statement work?
That almost does the trick. Here is the formula I am working with: =(c4-b4)+1 If there is nothing in b4, how do I make the "if" statement work?
