Error calculation
Reasons: Excel sometimes count also does not add and subtract. In fact, when entering numbers because Excel has the following agreement: If the use of “cell” command will have entered the number of cells as text, then Excel will remain as numerical data. If you enter a number in the cell before the text format as the future of the digital input is regarded as text, of such cells will be carried out in terms of summation error. For example, calculation of H1 = SUM (A1: G1), if A1: G1 For these reasons the region is set to text format, then H1 = 0.
Solution: The best use of the new worksheet to the number of air operations. Has been used as a worksheet, even if the original data has been deleted, but still retains its original formatting, may be regarded as the number of calculation errors caused by the text, and sometimes hard to find. However, there is a know-how (if listed as “the most appropriate column width” null and void after this Act), or text data by default left-justified, and the default value data for the right alignment, and so we can see whether there is any number of is set to the text.
Reasons: the formula or function or operator of the regional cell reference is not correct. Such as the use of SUM function on the A1: A5 and B1: B5 sum of the two regions, and, in applying the two did not cross the use of a cross-regional operator (space). Written in “SUM (A1: A5 B1: B5)” (Note: A5 and B1 spaces between) will be # NULL!ERROR s here: cross-operator region in order to prevent double counting when summing introduced. For example, the formula: “= SUM (A1: A3, A1: C1)” will repeat the sum cell A1 (plus two), while the formula “= SUM (A1: A3 A1: C1)” only to cell A1 for and one.
Solution: do not cross-sum of the region, such as not using the cross-operator operator, and to use a comma-separated regions summation. For example, the formula: “= SUM (A1: A5 B1: B5)” should be written: “= SUM (A1: A5, B1: B5)”.
# NAME? Mistake
Reason 1: function name input error. For example, edit the column formula mistakenly “E1 = SUM (A1: D1)” losers as “E1 = SYM (A1: D1)”, will be produced in the E1 cell # NAME?ERROR.
Solution: less skilled users, such as the best way to use the wizard function input function. For example: make the cursor stop to enter the formula in the cell, and then click Excel 2000 “editorial column” in the “Formula Editor” button (that is, an equal sign), will be “=” Insert column editor. Then click the “Name Box” button to open the right of the drop-down menu, select the function you need, click, open the “XXXX” (XXXX for the function name) dialog box, drag with the mouse to select the method of calculating the unit needs cell or range, after the completion click “OK.”
Reason 2: the text in the formula did not increase the use of double quotes, Excel 2000 will function as a name. For example, A1 = 68, A2 = 96, ifA1, B2, respectively, show the “health fee, 68″, “96 health fee,” and so on, can use the formula: “=” health fee “& A1 “,”=” health costs” & A2 “, if the text quoted (” health fee “), the lack of double apostrophe, there will be # NAME?ERROR.
Solution: in the formula do not forget to quote the text with double apostrophes.
3 reasons: the range reference function is missing a colon, a colon or other symbols have become lost. For example, the formula: “= SUM (A1C10)” calculation is # NAME?ERROR.
Solution: unskilled users the best way to use the mouse to drag the reference range. For example, you can edit in Excel 2000 column input: “= SUM ()”, and then let the cursor stay in the middle of the small brackets, and finally you drag with the mouse to calculate the range A1: C10, the “A1: C10 “will automatically enter the small brackets.
Reason 1: the cell containing the text of the numerical calculations, such as the A1 = 3, B1 = “6″ (with quotation marks that it is up to 6 text) or cell B1 enter the “date” word.
Solution: Check all those involved in cell operations. If the text contains a summation of the rows or columns, it is best to use SUM function, because the SUM function can be ignored in the calculation of the text when the cell is located.
2 reasons: the need for a single value in the operator or function in the region entered a value. For example, the calculation: “C1 = INT (A1: B2)”, while the results of C1 calculation # VALUE! .
Solution: modify the formula, will be replaced by one single region of the numerical values, such as the type will be changed to: “C1 = INT (A1)”.
##### Error
Cause 1: The results of the calculation is too long, to accommodate no less than the cell. For example, A1 = 1266.62, B2 = 1668.96, then C1 = A1 + B1 = 2935.58. If C1 is less than the width of 3.75 (12 words, depending on the use of different number of slightly different), there will be an error #####.
Solution: drag the column header with the ways to increase the border width of the cell until the correct result will be displayed. Or check out error, click “Format → → out the most appropriate column width” menu, so that column width automatically to the most appropriate value.
If the excessive number of decimal places can also be a cell by modifying the method of data formats to eliminate the error #####. Method is: select the wrong cells, and then click “Format” menu in the “cell” command, open the “digital” tab, select the “Category” under the “value”, select the appropriate decimal places number and decimal format “OK.”
2 reasons: If using this method can not eliminate the error, and a date or time, there may be negative results caused. For example, A1 = 1999-8-16, B1 = 1986-2-26, then C1 = B1-A1 ##### error will appear.
Solution: modify the calculation formula, so to calculate the date or time for the positive. In accordance with the method described above to set the cell value format, which is to calculate the date or time into a sequence number. Is as follows: Right-click the cell “#####” show (in this case is C1), on the shortcut menu, select “Format Cells” command. Open the “format cells” dialog box “digital” tab, select the “Category” under the “value”, and finally in the “negative” under the selected format you need, click “OK” to.
Reason 1: the formula or function assigned to the numerical input beyond its acceptable range. For example, “B6 = ACOS (A9)”, and A9 less than the value of -1 or greater than 1.
Solution: be sure to enter values in the formula or function of the acceptable range and to ensure that the type of function to use the correct parameters.
Reason 2: the numerical calculation have too big or too small, beyond the scope of Excel can be expressed, Excel 2000 can be expressed in the value -1 × 10307 and between 1 × 10307, if beyond the scope of the above will be # NUM!ERROR
lution: amend the formula so that the result in -1 × 10307 and between 1 × 10307.
