First, we have the divide by zero error.
You’ll see a NAME error when Excel does not recognize a name or formula.
In the first example, theAVERAGE functionis misspelled so it’s not recognized.
The NA error means that data is not available.
If B7 is blank or contains a normal value, the error disappears.
NA is also a common error when you’re usingVLOOKUPorMATCH.
It means that the lookup value is not found in the table or array.
In this case, Sushi is not in the table.
If we change the value in B12 to Pizza, all is well.
You might see the NUM error if a value is too large, as in this first example.
You’ll see a value error when the argument is not the expected bang out.
TheMONTH functioncan’t extract a month value from “apple” for the same reason.
To fix this problem, just enter using Control-Shift-Enter.
The REF error is one of the more common errors you’ll see.
It triggers when a reference becomes invalid, most often because cells have been deleted.
The NULL error is quite rare and shows up when you’ve specified two ranges that don’t intersect.
To illustrate, let’s look first at this small sales table.
In the formulas below, we are using the space character to specify the intersection of two ranges.
However, the third formula contains two ranges that do not intersect, so the formula returns NULL.
Now let’s look at the first example, which is a SUM function.
you’re free to see that this formula is unintentionally using a space instead of a comma.
The space is the range intersect operator and because B7 and B8 do not intersect, SUM returns NULL.
To fix this problem, just replace space with a comma.
To fix this error, just make the column wider.
