Excel error what does it mean?

Here is a quick post explaining the why are you getting the formula error and what does it mean. It's a most common problem for any Excel user for know excel formula error and identifying the formula becomes easy if we know why I'm getting this error?

#N/A

#N/A happens when a function like MATCH or VLOOKUP cannot find the value it is being asked to look for, therefore used formula is the syntax =IFERROR(value,value_if_error)" where value must be your required formula and value_if_error must be exception value

#REF!

#REF! errors happen whenever one or many cell references is deleted or moved. Excel tries to automatically update all references, but when it can’t do so, it replaces the actual cell reference with the error. hence make sure use proper reference for linking any cells

#DIV/0!

#DIV/0! the error happens when a mathematical operation attempts to divide by zero (which isn’t possible). Usually, this occurs because a COUNT or SUM results in zero and another cell is operating on its result.

#VALUE!

#VALUE! is likely the most common of errors. It occurs whenever the data type a function is given doesn’t match what it is expecting by the excel. Hence to overcome you must check the cell format of the referenced cell.

#NULL!

#NULL! gets returned when Excel can’t figure out the range specified in a cell. This can happen when you put a space between function inputs instead of using a comma (,). therefore you must

#NAME?

#NAME? appears when Excel can’t find a named range. Excel assumes that any unquoted string that isn’t a function name is a named range. You will most likely encounter this when you forget to quote a string or mistype a cell reference.