if error

[robert_woodie]

i have a macro that reads from a list of data which is autoimaticall
generated, some times the error #DIV0! is produced
i want to write
if cell.value=this error then
set variable to zero

how do i do this

 

[Don Guillett]

as always, post your coding efforts for comments

 

[moorso]

*i have a macro that reads from a list of data which i
autoimatically generated, some times the error #DIV0! is produced
i want to write
if cell.value=this error then
set variable to zero

how do i do this? *

I use the formula below. If M36 is zero, the result is an error and i
subsequently sets the value of the cell equal to 0.


=IF(ISERR(AN36/M36)=TRUE,0,AN36/M36