Which error appears when there is formula or function with 'invalid' numeric value ? How can you correct it ?

Correct #NUM! ERROR will appear if the formula or function will contain invalid numeric value. To correct it: 1. Optionally, click the cell that displays the error, and click the button that appears and then click “Show Calculation Steps.” 2. Review the possible causes and solutions – Using the unacceptable argument in a function that requires a numeric argument. 3. Make sure that arguments used in the function are numbers using a worksheet function that iterates, such as IRR or RATE and the function cannot find a result. 4. Use a different starting value for worksheet function. 5. Change the number of times Microsoft Office Excel iterates formulas.