Thread: IFERROR
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default IFERROR

If you are human just like us, sooner or later you will make an errort and
will need this function...

Seriously, ISERROR is used to suppress or take an alternate action if the
formula being tried generates and error. It is also used when many functions
are used together to build a large one. If any piece retruns an error the
whole fails. By testing for ISERROR one can recover from such situations.

"MMCBRIDE" wrote:

Why would I ever need this function?