##### error

When your cell contains this error code, the column isn"t wide enough to display the value.

You are watching: An error value begins with a(n) _____ followed by an error name that indicates the type of error.

*


1. Click on the right border of the column A header and boost the column width.

*

Tip: double click the right border of the column A header to immediately fit the widest enattempt in column A.

#NAME? error

The #NAME? error occurs as soon as Excel does not identify message in a formula.

*

1. Simply correct SU to SUM.

*

#VALUE! error

Excel displays the #VALUE! error as soon as a formula has actually the wrong type of debate.

*

1a. Change the value of cell A3 to a number. 1b. Use a function to ignore cells that contain message.

*

#DIV/0! error

Excel displays the #DIV/0! error as soon as a formula tries to divide a number by 0 or an empty cell.

*

1a. Change the value of cell A2 to a worth that is not equal to 0. 1b. Prevent the error from being presented by using the logical function IF.

*

Explanation: if cell A2 amounts to 0, an empty string ("") is displayed. If not, the outcome of the formula A1/A2 is presented.

#REF! error

Excel display screens the #REF! error as soon as a formula refers to a cell that is not valid.

1. Cell C1 referrals cell A1 and cell B1.

*

2. Delete column B. To achieve this, best click the column B header and also click Delete.

See more: How Can Mass Extinction Events Be Distinguished From Background Extinctions?

*

3. Select cell B1. The reference to cell B1 is not valid anyeven more.

*

4. To fix this error, you can either delete +#REF! in the formula of cell B1 or you have the right to unperform your action by pressing CTRL + z