#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
No comments:
Post a Comment