What’s that funny thing in my worksheet?
Sometimes Excel can’t calculate a formula because the formula contains an error.
If that happens, you’ll see an error value in a cell instead of a result.
#REF! A cell reference isn’t valid. Cells may have been deleted or pasted over.
Here are three common error values:
#NAME? You may have misspelled a function name or used a name that Excel doesn’t recognize.