Signs of

Document Sample
Signs of Powered By Docstoc
					Signs of error in Microsoft Office Excel and Solutions

While working at the office I sometimes signs of errors in Microsoft Office Excel,
of course, as you well right pegawau office. For those of you that school and told
to make a report to Excel usually never have problems like this and can fix most
of it again. and here I am on the error signal and solutions that facilitate our work
using Microsoft Office Excel.

Here I will present the mistakes that often occur, the cause of the error and how
to overcome them.
1. # # # # #
This error occurs when the column is not wide enough, or using a negative date
or time.
If the column is not wide enough, do one of the following steps:
Add a column width
Select the column by clicking the column header;
In the Home menu, Cells group, and under the Format, AutoFit Column Width
Or it could be a quick way, by double clicking on the right boundary column
Shrink fit the width of the column contents
Right-click on the cell, select Format Cells, Alignment, Shrink to fit.
Apply a different number format
In some cases, you can change the number format cells to make the number fit
within the width of the cell. For example, you can reduce the number of decimal
digits after the decimal point.
2. # DIV / 0!
This error occurs when there is a number that is divided by the number 0 (zero)
or use an empty cell reference.
To fix you can do one of the following:
Click on the cell that displays the error; click the button that appears (like the
exclamation mark), then click Show Calculation Steps.
Check the denominator in the formula, if 0 (zero) replace it with other numbers.
Check if you use the cell as a divisor is an empty cell or cells with the number 0
(zero), if so do the following: replace the reference cell with another cell that has
a value, enter a number other than 0 (zero) on the cell used as dividers .
3. # N / A
This error occurs when the value is not available for a function or formula.
Possible errors that occur are:
Missing data, and enter # N / A or NA () into a formula.
The solution is to replace # N / A with the new data.
Giving incorrect values for the arguments in the function HLOOKUP, LOOKUP,
The solution is to make sure that the arguments used are the proper value.
4. # NAME?
This error occurs when Microsoft Office Excel does not recognize text in a
Possible errors that occur are:
Entering text on a formula without enclosing the text in double quotes.
Excel attempted to translate entry (input) as a name (name) even though you
intend to memsukkannya as text. The solution is to enclose the text in the
formula in double quotes ("...").
Eg In cell A11 there is a formula intended to assemble the text "Total is" with no
numbers on A10 cells (such as the 100), the formula is as follows: = "Total is" &
So the result (in cell A11) is the total number is 100
Eliminating the colon (:) in the reference range (range).
Make sure that all references in the formula range using a colon (:); example,
SUM (A1: C10).
Referencing another worksheet without attaching it to the single quotation marks
If a formula leads to values or cells on another worksheet (or worksheets
Workbooks) and the name of the worksheet contains non Alphabetical characters
or spaces, you must enclose the name of the worksheet into the single quotation
marks (').
5. # NULL!
This error occurs when you define the intersection of two areas that do not
intersect.Intersection operator is a space between the reference.
This error may occur because:
Using the range operator (range) is wrong
To drive into the adjacent range of cells, use a colon (:) to separate the first cell
reference to reference the last cell in the range (range) is. For example, SUM
(A1: A10) shows the range of cells A1 through A10 cells.
To point to two areas that do not intersect, use the union operator (associations),
the comma (,). For example, if the formula is adding two ranges (range), make
sure that the comma is used to separate the range. Examples of formula (SUM
(A1: A10, C1: C10)).
6. # NUM!
This error occurs with numerical values that are not valid in the formula or
Possible errors occur when:
Using arguments were not accepted by the function (function) that require
numeric arguments / points.
The solution is to make sure that the arguments are put into the function is a
number.For example, if you want to enter the value of $ 500, then you should
enter 500 without Rp.
Enter a formula that generates the numbers are too big or too small for Excel.
The solution is to change the formula so that the result is between -1 and 1 * 10
307 * 10 307
7. # REF!
This error occurs when a cell reference is not valid.
Possible errors happen if you remove the cells used as a reference formula, or
move the cell to another cell that is used as a reference formula. The solution is
to change the reference formula, or click Undo immediately after you delete or
move the cell.
8. # VALUE!
This error occurs if the type of argument or operand is being used.
Examples of possible mistakes made is to enter text when the formula requires a
numeric or logical values such as TRUE or FALSE.
Microsoft Office Excel can not translate the text into the correct data type. Make
sure that the operands or arguments to the formula or function is correct, and
that the cells referenced by the formula contains the correct value. For example:
if cell A1 contains a number and cell A2 contains the text "Tea", formula = A1 +
A2 will display the following error sign # VALUE!.

Shared By: