Thread: Excel Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Excel Formula
=IF(OR(B4="",B4=0),"",C4-B4+1)

"Pat" wrote:

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?
Reply With QuoteReply With Quote