Excel Formula

[Pat]

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?

 

[Pete_UK]

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

Hope this helps.

Pete

 

[Pat]

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?

 

[Teethless mama]

=IF(OR(B4="",B4=0),"",C4-B4+1)