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. 


Thread Tools  Display Modes 
#1




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




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




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




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




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




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...omdisplaying/ Danny Rocks www.thecompanyrocks.com Dirr wrote: IFERROR in Excel 2007 16Apr08 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...sesavail.aspx 
Thread Tools  
Display Modes  

