Quote:
Originally Posted by GraemeSS
Problem is when I have formulas looking for data from the other sheets it assumes the next column has zero and I get a Div/0 error
|
Generally there are 2 ways:
=IF(DividorFormula = 0, ExpressionWhen0, YourFormula)
=IFERROR(YourFormula,ExpressionWhen0)