Which error occur when formula contain invalid data?
Answers
Answered by
3
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.
Answered by
1
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
Similar questions