Document Sample

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 headings. 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, MATCH, or VLOOKUP. 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 formula. 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" & A10 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 function. 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!.

DOCUMENT INFO

Shared By:

Categories:

Tags:

Stats:

views: | 16 |

posted: | 10/29/2012 |

language: | English |

pages: | 3 |

OTHER DOCS BY topekweb333

Docstoc is the premier online destination to start and grow small businesses. It hosts the best quality and widest selection of professional documents (over 20 million) and resources including expert videos, articles and productivity tools to make every small business better.

Search or Browse for any specific document or resource you need for your business. Or explore our curated resources for Starting a Business, Growing a Business or for Professional Development.

Feel free to Contact Us with any questions you might have.