Analysis and solution of WPS table error

People who believe that using the WPS form do not encounter errors. Know wrong to change, or a hero. Okay, nonsense, share immediately:

Error data one: #DIV/0
Reason analysis: In a formula that contains a division, a divisor refers to a 0-value cell or an empty cell (an Operation object is an empty cell, Excel handles it as a 0 value), or a value of 0 is used directly.
Error instance: Enter the formula "=A2/B2" and return the above error when B2 is "0" or empty.
Workaround: Modify the referenced blank cell, or enter a value that is not zero in the cell used as a divisor, or enter a number that is non-zero directly.

Small tip:
When making a blank form, in order for the error value to not appear, we can use the "IF" and "ISERROR" functions to process the formula, such as the input formula "=if (A2/B2)," ", a2/b2)", so that after processing, if the B2 is null or "0", the formula returns empty ( ""), on the contrary, the formula returns the correct result of the a2/b2 operation.

Error data two: #NAME?
Reason analysis: Text that Excel cannot recognize is used in a formula. For example, the name is wrong or deleted, the function name is misspelled, the text is quoted without quotation marks ("") or the quotation marks ("") in the Chinese state, and so on, and the functions in the add-in part, such as the Analysis ToolPak, are not loaded with the corresponding macros.
Error instance: input Formula "=datedif" ("1963-3-4", Today (), "Y") ", the parameter Y in the formula uses the double quotation mark in the Chinese state, returns the above error.
Workaround: For specific formulas, check the wrong objects individually and then correct them. If you reassign the correct name, enter the correct function name, add quotes, and so on, or load the corresponding macro.

Error data three: null!
Reason analysis: Using an incorrect area operator or incorrect cell reference, and so on.
Error instance: Enter Formula "=sum (a1:a10 e1:e10)", because the formula does not use a comma (,), and use a space, Excel cannot perform the sum operation, the formula returns an error.
Workaround: Check and correct the area operator, or modify the incorrect cell reference.

Error data four: #NUM!
Reason analysis: An unacceptable parameter is used in a function that requires a numeric parameter, for example, when you enter an open square formula (SQRT), a negative cell is referenced or a negative value is used directly; the formula produces a number that is too large or too small for Excel to represent.
Error instance: input Formula "=10^309", the formula returns an error because the result of the operation is too large.
Workaround: Check and correct the specified invalid value for the reference or the invalid value in the reference cell, change the formula so that the result is between -10^308 and +10^308 (if you need to perform an extra large, very small result, use a third-party software to process it).

Error data five: #REF!
Reason analysis: The cell referenced by the formula is deleted, and the system cannot be automatically adjusted, and the linked data is not available.
Error instance: Enter the formula "=A2+B2" and return the A2 and B2 cells if they are deleted at this time.
Workaround: Modify the invalid reference cell in the formula, and adjust the linked data so that it is in the available state.

Error data six: #VALUE!
Reason Analysis: Provides a range reference for operators or functions that require a single value, rather than a range, and when the formula requires a number or logical value, the text is entered, the array formula is entered and edited, but the "enter" key is used to confirm it.
Error instance: Enter the formula "=a8+b8", and if the A8 or B8 is text, the formula returns an error.
Workaround: Correct the relevant parameters, and when you enter the array formula, confirm with the "Ctrl+shift+enter" key combination when the input is complete.

Error data seven: #N/A
Reason analysis: The cited data is missing.
Error instance: The input formula "=vlookup (a9,2)" Returns the above error because the VLOOKUP function query area is missing from the formula.
Workaround: Under the guidance of the Function Wizard, check the parameters for omission and make additional corrections.

Error Data eight: # #
Reason analysis: the date operation result is negative; the date sequence exceeds the range allowed by the system; When the value is displayed, the cell is not wide enough.
Error instance: Enter a value of "20040123" in the cell and set the cell to date format, which returns the above error because it exceeds the date series value.
Workaround: Correct the date Operation formula so that the result is positive, make the entered date sequence within the system's allowable range (1~2958465), and increase the cell width.