Friday, January 22, 2010

Error In Excel

#DIV/0!
when formula try to divide a number by 0 or empty cell or empty string.

### error
When your cell's column isn't wide enough to display the value.

#NAME? error
The #NAME? error occurs when Excel does not recognize a formula.

#VALUE! error
when a formula has the wrong type of argument for fill the formula's process or formula's calculate.

#REF! error
when a formula refers to a cell that is not valid or empty.

#N/A

#NULL

Formula:
IFERROR
ISERROR

Circular Reference

Floating Point Errors / Scientific Notation
rounding a number
ROUND
ROUNDUP
ROUNDDOWN
MROUND
chop or cut off floating point
INT
TRUNC

CEILING
FLOOR

EVEN
ODD