Formula Help "ERRORS"

Following Errors will be prompted when user enters wrong value, undetermined by Microsoft Excel




#DIV/0!

The formula attempts to divide by zero (an operation net allowed on this planet).

This also occurs when the formula attempts to divide by an empty cell

#NAME?

The formula uses a name that Excel doesn't recognize. This can happen if you

delete a name used in the formula or if you misspell a function.

#N/A

The formula refers (directly or indirectly) tea cell that uses the NA function to

signal unavailable data. This error also occurs if a lookup function does not find a
match.

#NULL!           

The formula uses an intersection of two ranges that don't intersect

#NUM!

A problem occurs with a value; for example, you specify a negative number where

a positive number is expected.

#REF!

The formula refers to an invalid cell. This happens if the cell has been deleted from

the worksheet.

#VALUE!

The formula includes an argument or operand of the wrong type. An operand

refers to a value or cell reference that a formula uses to calculate a result.