Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eliminate ALL cells containing the same data | Excel Discussion (Misc queries) | |||
Modify to eliminate #NUM! error | Excel Worksheet Functions | |||
Eliminate zero value cells in an EXCEL chart | Charts and Charting in Excel | |||
Eliminate matching cells | Excel Discussion (Misc queries) | |||
How do I eliminate, in Excel XP, "too many cell formats" error? | Excel Discussion (Misc queries) |