Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    Untitled

    Uploaded by

    Helen Muriuki
    This document discusses various error values that may occur in Excel formulas and their potential causes and solutions. It outlines 8 common error values: #N/A, #DIV/0!, #NULL!, #NAME?, #NUM!, #VALUE!, and #REF!. For each one, it provides examples of what might cause the error and recommendations for resolving it, such as changing formulas, correcting cell references or widths, ensuring functions have the right arguments, and avoiding zero values in divisions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Untitled

    Uploaded by

    Helen Muriuki
    36 views2 pages
    This document discusses various error values that may occur in Excel formulas and their potential causes and solutions. It outlines 8 common error values: #N/A, #DIV/0!, #NULL!, #NAME?, #NUM!, #VALUE!, and #REF!. For each one, it provides examples of what might cause the error and recommendations for resolving it, such as changing formulas, correcting cell references or widths, ensuring functions have the right arguments, and avoiding zero values in divisions.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses various error values that may occur in Excel formulas and their potential causes and solutions. It outlines 8 common error values: #N/A, #DIV/0!, #NULL!, #NAME?, #NUM!, #VALUE!, and #REF!. For each one, it provides examples of what might cause the error and recommendations for resolving it, such as changing formulas, correcting cell references or widths, ensuring functions have the right arguments, and avoiding zero values in divisions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    36 views2 pages

    Untitled

    Uploaded by

    Helen Muriuki
    This document discusses various error values that may occur in Excel formulas and their potential causes and solutions. It outlines 8 common error values: #N/A, #DIV/0!, #NULL!, #NAME?, #NUM!, #VALUE!, and #REF!. For each one, it provides examples of what might cause the error and recommendations for resolving it, such as changing formulas, correcting cell references or widths, ensuring functions have the right arguments, and avoiding zero values in divisions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    FORMULAS AND ERROR VALUES.

    If a formula cannot properly evaluate a result, Ms-Excel will display an error value.

    For example, error values can be as a result of using text where a formula expects a numeric value,
    deleting a

    cell that is referenced by a formula, or using a cell that is not wide enough to display the result.

    1. #####

    Causes. This error value occurs when the cell contains a number, date or time that is wider than the cell.

    -OR- It occurs when the cell contains a date or a time formula that produces a negative result.

    Suggested action.

    (i). Increase the width of the column by dragging the boundary between the column headings.

    (ii). Apply a different number format in the cell to make the number fit within the existing cell width.

    E.g., decrease the no. of decimal places after the decimal point.

    (iii). Ensure that the data and time formulas are correct. When you subtract dates and times, make sure

    you build the formula correctly.

    2. #N/A. The #NA error value occurs when a value is not available to a function or formula.

    Possible cause Suggested action

    (i). Omitting 1 or more arguments in a function Enter all arguments in the function.

    3. #DIV/0!. This error value occurs when you enter a formula that contains a division by zero (0).

    E.g., =5/0. It may also occur when you divide a cell by another cell that is blank.

    Suggested action.

    (i). Change the divisor to a number other than zero.

    4. #NULL!.The #NULL! error value occurs when you specify an intersection of two areas that do not

    intersect. i.e., using an incorrect range operator or using an incorrect cell reference.

    Suggested action.

    (i). Use the correct range operator. For instance, to refer to two areas that don’t intersect, use the
    Comma.

    E.g. if the formula sums two ranges, separate the two ranges with a comma.

    =SUM(A1:A9,C1:C6).

    (ii). Check for typing errors in the reference to the ranges.


    5. #NAME?.The #NAME? error value occurs when Ms-Excel doesn’t recognize text in a formula.

    Possible cause Suggested action

    (i). Deleting a name used in the formula, or Make sure the name exists.

    using a name that does not exist

    (ii). Misspelling the name of a function Correct the spelling.

    (iii). Omitting a colon (:) in a range reference Make sure all range references in the

    formula use a colon.

    E.g. =SUM(A1:A5)

    (iv). Entering text in a formula without Enclose text in the formula in double

    46

    enclosing the text in double quotation marks (“). quotation marks.

    Ms-Excel tries to interpret your entry as a name E.g. the following formula joins a

    even though you intended it to be used as text. piece of text “The total amount is”

    with the value in cell B5:

    =”The total amount is” & B5

    6. #NUM! This occurs when a problem occurs with a number in a formula or function. E.g., Entering a

    formula that produces a number to a number that is too large or too small to be represented in Ms-
    Excel.

    Suggested action

    (i). Change the formula so that its result is between – 1*10307 and 1*10307

    7. #VALUE!.The #VALUE error value occurs when the wrong type of argument or operand is used.

    8. #REF!.The #REF error value occurs when a cell reference is not valid. For instance, deleting cells
    referred

    to by other formulas, or pasting moved cells over cells referred to by other formulas.

    Suggested action

    (i). Change the formulas, or restore the cells on the worksheet by clicking Undo immediately after you

    delete or paste the cells.

    You might also like