-
#VALUE error occurs when either the arguments to a function are of the wrong data type or the formula returns one type and the cell is formatted to accept another.
-
#N/A error occurs there is a problem with the formula, for example incorrect syntax or an unexpected error.
-
#NAME error occurs when trying to use a function that is not supported by j5
-
#DIV/0 error occurs when answers are undefined, most often by dividing by zero