View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcmilja mcmilja is offline
external usenet poster
 
Posts: 35
Default Need an alterate result to "0" for null value

Hello,

I have a worksheet that references cells from another worksheet but if the
cell is blank, it produces a "0". This "0" is changing the behavior of other
formulas so is there a formula I can use that will either change the "0" to a
blank or #N/A?

Thanks,
Jaret