DIV/0 ERROR - How to get rid of it in many cells in one go?

  • Thread starter Thread starter Doria/Warris
  • Start date Start date
D

Doria/Warris

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
 
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
Click to expand...

Not a good formula even as an example. You return a string in one
instance and a value in another. Your TRUE return should be 0 if you
you want a zero displayed OR you should test for NOT is error and use
your FALSE return as you true and leave the false null. As you start to
do more with Excel you will understand the consequences of mixing
strings and values. You are now experiencing someone who chose to use a
lesser quality formula because it 'worked for them now'... :)
 
Back
Top