if error

R

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
 
M

moorso

robert_woodie said:
*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? *
Click to expand...

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
 
Top