Question

Which error occur when formula contain invalid data?

Answer 1

Answer:

The #REF! error is one of the most common errors you'll see in Excel formulas. It occurs when a reference becomes invalid. In many cases, this is because sheets, rows, or columns have been removed, or because a formula with relative references has been copied to a new location where references are invalid.

Answer 2

Answer:

An invalid cell reference error occurs when a formula contains incorrect cell references. This happens most often when: Individual cells or entire columns or rows containing data referenced in a formula are accidentally deleted