ISERROR

[joharmenezes]

I have an excel sheet with a lot of different formulas but I had not taken any precautions for handling errors. I know errors can be handled by using iserror but that means I would have to manually enter each and every formula again. For example, I need to replace the formula YTD!E15 to IF(ISERROR(YTD!E15/10),"",YTD!E15/10) but that means I would have to manually type this formula in every cell. I'd like to know if there is an easier way to do this?

 

[NARAYANK991]

Hi ,


Do you think this will be of help ?


http://www.excelbanter.com/showthread.php?t=251747


Narayan

 

[joharmenezes]

Thanks NARAYANK991!