View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Metallo[_2_] Metallo[_2_] is offline
external usenet poster
 
Posts: 5
Default DIV/0 ERROR - How eliminate them in many cells contemporaneously

Hi,

Normally, I use the formula (EXAMPLE):
=IF(ISERROR(G12/G11*1000),"",G12/G11*1000)

In this way I prevent the error to appear.

The problem is that somebody sent me a very big Excel file with plenty
of DIV Errors, therefore I am asking how I can apply my formula to all
of them in one go.
Certainly, I cannot do this cell by cell and I am sure there is a
"batch" process I can use.

Thanks for your help

Alex