Thread: IFERROR in Excel 2007
View Single Post
  #2  
Old April 16th, 2008, 11:55 PM posted to microsoft.public.excel.worksheet.functions
daddylonglegs
external usenet poster
  
Posts: 289
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.