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)



"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.

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

Regrads,
Fred.

"Dirrk" wrote in message
...
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.

On Wed, 16 Apr 2008 15:31:01 -0700, 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.

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

"Dirrk" wrote in message
...
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.

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/preve...om-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 have
to do this for work and cannot find anything on it.

Previous Posts In This Thread:

On Wednesday, April 16, 2008 6:31 PM
Dirr wrote:

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

On Wednesday, April 16, 2008 6:55 PM
d.addylongleg wrote:

Did you try Excel help?
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:

On Wednesday, April 16, 2008 6:57 PM
Fred Smith wrote:

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

Regrads,
Fred.

On Wednesday, April 16, 2008 8:21 PM
Ron Rosenfeld wrote:

IFERROR in Excel 2007
wrote:


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

On Thursday, April 17, 2008 1:40 AM
Tyro wrote:

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/tutorials...ses-avail.aspx