| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IFERROR in 2003 version
All ...
Is there an equivalent to IFERROR (Excel 2007) that I can use so as to save functionality when being viewed in Excel 2003? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IFERROR in 2003 version
Hi Drew
Unfortunately, no. You will need to use something to trap for the error so that it will work in both versions. Obviously it could be =IF(ISERROR(your_formula),"",your_formula) but dependent upon what your_formula is, it may be possible to use an easier (faster) test to see whether Null or your_formula should be returned. If you want to post back with your actual formula, maybe we can suggest a different test. -- Regards Roger Govier "Drew" wrote in message ... All ... Is there an equivalent to IFERROR (Excel 2007) that I can use so as to save functionality when being viewed in Excel 2003? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IFERROR in 2003 version
Thanks Roger ... a couple of examples are below.
=IF(I5="","",IFERROR(C11-SUM(F3*I5),"")) =IF(I5="","",IFERROR(SUM(F11,I11,L11),"")) =IF(H12="","",IFERROR(G12*$I$5,"Section 1 First")) Also ... is EDATE supported in 2003? "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Drew Unfortunately, no. You will need to use something to trap for the error so that it will work in both versions. Obviously it could be =IF(ISERROR(your_formula),"",your_formula) but dependent upon what your_formula is, it may be possible to use an easier (faster) test to see whether Null or your_formula should be returned. If you want to post back with your actual formula, maybe we can suggest a different test. -- Regards Roger Govier "Drew" wrote in message ... All ... Is there an equivalent to IFERROR (Excel 2007) that I can use so as to save functionality when being viewed in Excel 2003? Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IFERROR in 2003 version
Hi Drew
If they are numerical values in the cells, then you don't really need the error traps. If any values are 0, then you may end up with a zero result, but none of the formulae shown are divisions, hence there will not be a #DIV/0 error You could use =IF(I5="","",IF(COUNT(C11,F3,I5)<3,"",C11-(F3*I5))) Since none of the formulae are really complex, then you could simply use =IF(I5="","",IF(ISERROR(C11-(F3*I5)),"",C11-(F3*I5))) EDATE is available in XL2003, provided you have the Analysis Toolpak installed, ToolsAddinsAnalysis Toolpak. -- Regards Roger Govier "Drew" wrote in message ... Thanks Roger ... a couple of examples are below. =IF(I5="","",IFERROR(C11-SUM(F3*I5),"")) =IF(I5="","",IFERROR(SUM(F11,I11,L11),"")) =IF(H12="","",IFERROR(G12*$I$5,"Section 1 First")) Also ... is EDATE supported in 2003? "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Drew Unfortunately, no. You will need to use something to trap for the error so that it will work in both versions. Obviously it could be =IF(ISERROR(your_formula),"",your_formula) but dependent upon what your_formula is, it may be possible to use an easier (faster) test to see whether Null or your_formula should be returned. If you want to post back with your actual formula, maybe we can suggest a different test. -- Regards Roger Govier "Drew" wrote in message ... All ... Is there an equivalent to IFERROR (Excel 2007) that I can use so as to save functionality when being viewed in Excel 2003? Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IFERROR in 2003 version
Roger ... thank you kindly. The second option worked fine in all cases with
some ammendment specific to the cells formula requirement. Cheers. "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Drew If they are numerical values in the cells, then you don't really need the error traps. If any values are 0, then you may end up with a zero result, but none of the formulae shown are divisions, hence there will not be a #DIV/0 error You could use =IF(I5="","",IF(COUNT(C11,F3,I5)<3,"",C11-(F3*I5))) Since none of the formulae are really complex, then you could simply use =IF(I5="","",IF(ISERROR(C11-(F3*I5)),"",C11-(F3*I5))) EDATE is available in XL2003, provided you have the Analysis Toolpak installed, ToolsAddinsAnalysis Toolpak. -- Regards Roger Govier "Drew" wrote in message ... Thanks Roger ... a couple of examples are below. =IF(I5="","",IFERROR(C11-SUM(F3*I5),"")) =IF(I5="","",IFERROR(SUM(F11,I11,L11),"")) =IF(H12="","",IFERROR(G12*$I$5,"Section 1 First")) Also ... is EDATE supported in 2003? "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Drew Unfortunately, no. You will need to use something to trap for the error so that it will work in both versions. Obviously it could be =IF(ISERROR(your_formula),"",your_formula) but dependent upon what your_formula is, it may be possible to use an easier (faster) test to see whether Null or your_formula should be returned. If you want to post back with your actual formula, maybe we can suggest a different test. -- Regards Roger Govier "Drew" wrote in message ... All ... Is there an equivalent to IFERROR (Excel 2007) that I can use so as to save functionality when being viewed in Excel 2003? Thank you. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IFERROR in 2003 version
вторник, 8 апреля 2008*г., 13:32:30 UTC+5 пользователь Roger Govier написал:
Hi Drew If they are numerical values in the cells, then you don't really need the error traps. If any values are 0, then you may end up with a zero result, but none of the formulae shown are divisions, hence there will not be a #DIV/0 error You could use =IF(I5="","",IF(COUNT(C11,F3,I5)<3,"",C11-(F3*I5))) Since none of the formulae are really complex, then you could simply use =IF(I5="","",IF(ISERROR(C11-(F3*I5)),"",C11-(F3*I5))) EDATE is available in XL2003, provided you have the Analysis Toolpak installed, ToolsAddinsAnalysis Toolpak. -- Regards Roger Govier "Drew" wrote in message ... Thanks Roger ... a couple of examples are below. =IF(I5="","",IFERROR(C11-SUM(F3*I5),"")) =IF(I5="","",IFERROR(SUM(F11,I11,L11),"")) =IF(H12="","",IFERROR(G12*$I$5,"Section 1 First")) Also ... is EDATE supported in 2003? "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi Drew Unfortunately, no. You will need to use something to trap for the error so that it will work in both versions. Obviously it could be =IF(ISERROR(your_formula),"",your_formula) but dependent upon what your_formula is, it may be possible to use an easier (faster) test to see whether Null or your_formula should be returned. If you want to post back with your actual formula, maybe we can suggest a different test. -- Regards Roger Govier "Drew" wrote in message ... All ... Is there an equivalent to IFERROR (Excel 2007) that I can use so as to save functionality when being viewed in Excel 2003? Thank you. I have smilar problem my excel 2003 cannot read Iferror function. Ive tried to use "IF(ISerror(" instead of Iferror but it coming out as False or empty cells. Can anyone help me! I need to convert this function to make it readoble in excel 2003. "=_xlfn.IFERROR(INDEX('List of ICT Contracts'!$A$3:$A$56,SMALL(IF($B$2='List of ICT Contracts'!$G$3:$G$56,ROW('List of ICT Contracts'!$A$3:$A$56)-2,""),ROW()-4)),"")" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time for IFERROR? | Excel Worksheet Functions | |||
| download trial version excel 2003? can only find trial version 200 | Excel Discussion (Misc queries) | |||
| links between 2007 version files and 97-2003 version files | Links and Linking in Excel | |||
| version 2002 Vs 2003 | Excel Discussion (Misc queries) | |||
| Microsoft XP and 2003 version | Excel Discussion (Misc queries) | |||
![Drew[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
