Excel formula Errors

Sometimes your Excel formula may return an error message. Before you know how to correct or hide formula errors. The first thing you should know is to understand what each error type means.

Below are few possible error types:-

#Name?

– Means that you entered something in your formula that Excel interprets as an incorrect reference cell, range or function name.

#REF!

  • Indicates that you might have relocated or deleted a cell that is referenced in the formula.

#Value!

  • Tells you that you are probably usingtext in a formula when another argument (probably a number) is required.

#DIV/0

  • Occurs when you divide a number by zero or divide by a reference to an empty cell

#NUM!

  • Occurs when you try to pass an incorrect argument, like text, to a function that is expecting a numerical value
######
  • means that a number is too wide to be displayed in the cell
If you wish to know more information about Excel functions  and fix the error message, just google it. 🙂

How to use Absolute and Relative Cell in Excel

In Excel there are two types of cell references, these are Relative and Absolute.

An absolute cell reference consists of the column letter and row number surrounded by dollar signs ( $ ).

A relative cell reference consists of the column letter and row number that intersect at the cell’s location . Relative ranges do not use the $ character.

The $ character indicates to Excel that it should not increment the column and/or row reference as you fill a range with a formula or as you copy a range.

In summary, most cell references in a spreadsheet are relative cell references, which change when copied and pasted to other cells.Whereby absolute cell reference does not change when it a formula is copied and pasted to other cells. Continue reading