The IFERROR() Function in Excel 2007
in [Functions]
|
Prev: how to sum cells and ignore the #div/0! 's ?
Next: ¿cómo puedo conbinar formulas entre hojas de exel ?
From: Danny on 25 Apr 2010 17:08 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 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: Re: 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/aspnet/5261083e-6e03-4b25-8728-fc3cf6855293/free-online-courses-avail.aspx |