A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

IFERROR in Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2008, 11:31 PM posted to microsoft.public.excel.worksheet.functions
Dirrk
external usenet poster
 
Posts: 1
Default IFERROR in Excel 2007

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.
Ads
  #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.

  #3  
Old April 16th, 2008, 11:57 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
 
Posts: 2,386
Default IFERROR in Excel 2007

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.


  #4  
Old April 17th, 2008, 01:21 AM posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default IFERROR in Excel 2007

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
  #5  
Old April 17th, 2008, 06:40 AM posted to microsoft.public.excel.worksheet.functions
Tyro[_2_]
external usenet poster
 
Posts: 1,104
Default IFERROR in Excel 2007

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.



  #6  
Old April 25th, 2010, 10:08 PM posted to microsoft.public.excel.worksheet.functions
Danny Rocks
external usenet poster
 
Posts: 1
Default The IFERROR() Function in Excel 2007

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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.