stuck with iserror

[stuartford]

im using the following formula and need to get rid of the DIV/0
the formula is very simple but i cant get iserror to work on it

sum('sheet 2'!d30:d31)/sheet2 d32*100000

where and how do i put the iserror

cheers stu

 

[Scott Huish]

You don't need ISERROR, you just need to check for 0 in D32.

Perhaps:

=IF(Sheet2!D32=0,"",SUM(Sheet2!D30:D31)/Sheet2!D32*100000)

 

[Oaktree]

you could do
=if(iserror(sum('sheet 2'!d30:d31)/'sheet 2'!d32*100000),"",sum('sheet 2'!d30:d31)/'sheet 2'!d32*100000)

or, =if('sheet 2'!d32=0,"",sum('sheet 2'!d30:d31)/'sheet 2'!d32*100000)

 

[stuartford]

cheers gents

as usual thanks for the help


Stu