Question

Identify the error that appears when there are invalid numeric values in a formula or function. How can this error be rectified? Explain.

Answer 1

The error is #NUM! Error. The steps to correct it are:

1. Optionally, click the cell that displays the error, click the button that appears and then click show calculation steps. 

2. Review the following causes and solutions:

• Using an unacceptable argument in the function that requires anumeric argument. 
• Make sure that the arguments used in the function are numbers. 
• Using a worksheet function that iterates, such as IRR or RATE, and the function cannot find the result. 
• Use a different starting value for the worksheet function.

3. Then click the Microsoft button > Excel option and then click the formulas category.