How to avoid error messages in Excel2007

After you enter or edit a formula in Excel2007, you may not be able to calculate the result correctly, Excel2007 will display an error message, and the cause of the error is not all caused by errors in the formula itself. Here's a list of five error messages that are common in Excel, and how to correct them.

Error message 1-####

The data entered into a cell is too long or the result of a cell formula is too large to appear in the cell when it is not displayed. You can modify the width of a column by adjusting the bounds between the column labels.

If you want to subtract dates and times, make sure the format is correct. The date and time in Excel must be positive. If the date or time produces a negative value, it will appear in the entire cell. If you still want to display this value, click Cells on the Format menu, click the Number tab, and then select a format that is not a date or time.

Error message #DIV/0!

The input formula contains an obvious divisor of 0, for example-120/0, which results in an error message div/0!.

or the divisor in the formula uses an empty cell (when the Operation object is a blank cell, Excel interprets the null value as zero) or a cell reference that contains a 0-value cell. The workaround is to modify the cell reference or enter a value that is not zero in the cell that is used as the divisor.

Error message #VALUE!

Error message #value! occurs when an incorrect parameter or operator is used, or if the formula cannot be corrected when an AutoCorrect formula function is performed.

Excel cannot convert text to the correct data type when you need a number or logical value to enter text. You should confirm that the formula or function requires the correct operator or parameter, and that the formula refers to a cell that contains a valid number. For example, if cell B3 has a number and cell B4 contains text, the formula =B3+B4 returns an error message #value!.

#NAME is the error message?

An error message is generated when you use text that is not recognized by Excel in a formula #name? You can check to correct errors in the following ways:

(1) If you use a nonexistent name to produce such an error, you should confirm that the name you are using does exist. On the Insert menu, point to Name, click Define, and if the name you want is not listed, use the Define command to add the appropriate name.

(2) If it is a name, the spelling error of the function name should be modified.

(3) Confirm that all the range references used in the formula use a colon (:). For example: SUM (A1:C10).

Notice that the text in the formula is enclosed in double quotes.

Error message #NUM!

An error message #num! occurs when an incorrect number is used in a formula or function.

To resolve the problem, first confirm that the parameter types used in the function are correct. There is also a possibility that the number generated by the formula is too large or too small, Excel can not say, if this is the case to modify the formula, so that the results between -1x10307 and 1x10307.

Note : More wonderful tutorials Please pay attention to the triple computer Tutorials section, triple Office group: 185219299 welcome you to join