View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 287
Default IFERROR in Excel 2007

Did you try Excel help?

The basic syntax is like this

=IFERROR(value,value_if_error)

so to avoid #DIV/0! errors for instance you could use

=IFERROR(A1/B1,0)



"Dirrk" wrote:

I need an example on writing an IFERROR in Excel 2007. =IFERROR......I have
to do this for work and can't find anything on it.