If statement with next record

Originally Posted by Glenn Kennedy

You haven't told us what the formula is... A sample sheet would be helpful too...

however, =IFERROR(1/(1/your_formula),"")

will remove all those zeros, by converting them to a #DIV/0! error and then removing the error message

Note that this will only work on numbers and not on text.