Thread: Formula returning a blank cell if answer is zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chris Premo Chris Premo is offline
external usenet poster
  
Posts: 37
Default Formula returning a blank cell if answer is zero
Rich wrote:

In Excel 2003, I have a worksheet that has formulae in a column. If
the result is zero, it displays a zero. I copied the column to
another worksheet and on that worksheet, if the result is zero, the
cell is blank. Where is the switch to have it show zero or show
blank? I'm quite sure it exists...I just don't know where.

Thanks,



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

--

Reply With QuoteReply With Quote