IFERROR in Excel 2007

  • Thread starter Thread starter Dirrk
  • Start date Start date
D

Dirrk

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.
 
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)
 
Why not just look it up in Help? It will give you examples. Wouldn't that be
the easiest?

Regrads,
Fred.
 
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.
Click to expand...

Can't find anything? There are explanations and examples in HELP. Perhaps you
should tell us why that didn't have what you needed.
--ron
 
Perhaps a book on Excel? Such as Excel 2007 Bible by John Walkenbach. $40.
Money well spent.

Tyro
 
The =IFERROR()function is brand new - introduced in Excel 2007. It is easy to use - only two arguments required. And you can display any text in the cell if the formula returns an error. Simply enclose your text in " ".

Here is a link to a 4 minute video lesson that I created on this function:

http://www.thecompanyrocks.com/preventing-formula-errors-from-displaying/

Danny Rocks
www.thecompanyrocks.com



Dirr wrote:

IFERROR in Excel 2007
16-Apr-08

I need an example on writing an IFERROR in Excel 2007. =IFERROR......I hav
to do this for work and cannot find anything on it.

Previous Posts In This Thread:

IFERROR in Excel 2007
I need an example on writing an IFERROR in Excel 2007. =IFERROR......I hav
to do this for work and cannot find anything on it.

Did you try Excel help?
Did you try Excel help

The basic syntax is like thi

=IFERROR(value,value_if_error

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

=IFERROR(A1/B1,0


:

Why not just look it up in Help?
Why not just look it up in Help? It will give you examples. Wouldn't that b
the easiest

Regrads
Fred.

Re: IFERROR in Excel 2007
wrote

Can't find anything? There are explanations and examples in HELP. Perhaps yo
should tell us why that did not have what you needed
--ron

Perhaps a book on Excel?
Perhaps a book on Excel? Such as Excel 2007 Bible by John Walkenbach. $40
Money well spent

Tyro


Submitted via EggHeadCafe - Software Developer Portal of Choice
Free Online Courses Available for Eggheadcafe.com Users
http://www.eggheadcafe.com/tutorial...8-fc3cf6855293/free-online-courses-avail.aspx
 
Back
Top