CALC! | Excel is stuck and can’t finish the calculation. | Check for circular formulas or too many complex calculations. Simplify the formula. |
#DIV/0! | You tried dividing a number by zero or an empty cell. | Make sure the cell you’re dividing by has a number and isn’t zero. |
#N/A | Excel couldn’t find the value you were looking for. | Check your lookup value and range. Make sure the item exists in the data. |
#NAME? | Excel doesn’t recognize the formula or text you typed. | Fix typos in formula names or add quotes around text. |
#NULL! | You used the wrong symbol between cell references. | Use : for ranges (like A1:A10), not a space. |
#NUM! | There’s a problem with a number—like trying to square root a negative. | Check your math. Make sure numbers are valid and not too large or small. |
#REF! | A cell reference is broken—usually because you deleted something. | Don’t delete cells used in formulas. Recheck the formula and fix the reference. |
#SPILL! | Excel wants to show multiple results, but there’s something blocking the space. | Clear nearby cells so Excel can “spill” the results properly. |
#VALUE! | Excel expected a number but got something else—like text. | Check your formula inputs. Make sure you’re using the right data types. |
