When using Excel for report processing, in the process of operation, the program appears the error prompts "#NUM".
The cause of this error is not unique, summed up mainly in the following two kinds.
1. In the calculation process, the value that is entered into a function or formula exceeds the range that it can receive. To avoid this, you should ensure that the function's argument type is correct, and that the value entered is within the range acceptable to the formula or function.
2. The calculated result value is beyond the range that Excel can represent. To avoid #num errors, you need to ensure that the results are within the range that Excel can represent.