Step 2 To replace the "#NUM!" errors with the text string "a negative number," enter the following formula in cell B2 "=IFERROR(SQRT(),"A Negative Number")" Press the "Enter" key Drag the formula till cell B8 The output of the formula is shown in column B of the following imageHowever, if you click in the cell and hit return, it displays the result of the formula as expected If you save that excel sheet and then unarchive it, you will find the entry in the corresponding XML file is not IFS, but _xlfnIFS When I altered my code to specify theError value Cause The Excel workbook contains a function that is not supported in the version of Excel that you are currently running For example, you may have opened a workbook that contains the IFERROR function, which is not supported in versions of Excel earlier than Excel 07
How To Correct A Name Error
