Hi,
I have a query with regard to a workbook that I am trying to piece together to get it to work in 2003 (someone on here kindly posted the workbook up regarding a process that I would like to understand more but didn't indicate that it was likely to be 2007 or newer only). In short most of the sheet looks like it has formula in it that is 2003 compatible (e.g. everything seems to be turning up numbers) - however I have a number of formulas with IFERROR's in them that are turning up blanks and was wondering if there is a workaround for this to substitute for that there is no IFERROR in 2003?
The following are cells/formulas that are causing issues
=_xlfn.IFERROR(MAX(OFFSET($AJ$9,0,0,$J$10,1)-OFFSET($AK$9,0,0,$J$10,1)),"")
=_xlfn.IFERROR(MAX(OFFSET($AK$9,0,0,$J$10,1)-OFFSET($AF$9,0,0,$J$10,1)),"") - this was an array so I'll add the brackets back in afterwards
=_xlfn.IFERROR(ABS(MAX(J17:J18)),"")
=_xlfn.IFERROR(J19*SQRT($J$10),"")
=_xlfn.IFERROR(HLOOKUP(J19,KSDTableH,2),"")
=IFERROR(IF(AG9<>"",NORMDIST(AH9,$J$11,$J$12,1),""),"")
=_xlfn.IFERROR(IF(AG13<>"",NORMDIST(AH13,$J$11,$J$12,1),""),"")
Not knowing specifically what an IFERROR is or what an xlfn.IFERROR is, I was wondering if a workaround is possible or feasible?
Thanks in advance for any assistance
Bookmarks