Remove #DIV/0

[leonv01]

Hi, I'm looking for a solution to mask or hide "#DIV/0" cells in my workbook. Would be nice when I do not have to change all formulas because there are a lot in the workbook..

Many thnaks for your help!

 

[SteveO59L]

=if(iserror(a1/b1),0,a1/b1)

 

[leonv01]

and if the formula is like this: =SUM(N14:Q14)

 

[number kruncher]

Where any formula has a chance of giving an error, wrap it in...

=IFERROR('original formula',0)

 

[SteveO59L]

=if(iserror(SUM(N14:Q14)),0,SUM(N14:Q14))

 

[pgc01]

Hi

The error #DIV/0 is cause by a quotient equal to zero, so you just have to test the quotient.

In a case like

=a/b

just test

=if(b<>0,a/b,"error")

 

[leonv01]

thnx!

 

[leonv01]

would like to have the same solution for this formula: =SUMIF($F$11:J58,"Points",I11:I53)

Thnx!

 

[Jon von der Heyden]

That formula won't be the cause of any #DIV/0 error. It is likely that those errors are in column I, so visit column I and apply the fix that PGC suggested.