Next: Menus
Up: Formulas
Previous: Functions
Errors are of the form #ERROR?, where ERROR is the type of error.
There are several errors that are possible when entering formulas:
- #PAREN: Missing a parenthesis.
Example: =SUM(A1:A25
- #NUM?: Improper number format.
Example: 2.3.4
- #OP?: Improper use of an operator.
Example: =2++3
- #NAME?: An unknown syntax.
Example: =AD
- #REFS?: A cell that does not exist has been referenced.
- #ADDR?: An invalid cell has been referenced.
Example: =1A
- #EVAL?: The input cannot be evaluated properly.
Example: =A4:B4+1
- #FUNC?: An unknown function has been used
Example: =NOP()
- #PARAM?: Too many or too few arguments specified.
Example: =MIN()
Next: Menus
Up: Formulas
Previous: Functions
Daniel Medina
2000-12-10