Thread: Blank if zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Weston Cook Weston Cook is offline
external usenet poster
 
Posts: 1
Default Blank if zero

Hi,
I'm wondering if there is a function similar to "iferror" that will leave a cell blank if the result of its formula equals zero. I normally do something like:

if(A1-A20, A1-A2, "")

This gets tedious and difficult to follow with long and/or nested formulas, so I'm looking for a shortcut. Does such a thing exist?