write the cause of the following error occurs in a spreadsheet of
#REF!
Answers
Answered by
1
Explanation:
1 Name Error ( #NAME? ) This error awhenever Excel is not able to recognize the text in the formula. ...
Value Error ( #VALUE! ) ...
Division Error ( #DIV? ...
Null Error ( #NULL! ) ...
Reference Error ( #REF! ) ...
- 10 Time Saving Excel Shortcuts.
Answered by
2
Answer:
The #REF! error in a Excel appeares if u are running in a formula that is reffering to a cell that could not exist . If u delete a cell , column or row in a spreadsheet , and build a formula including a cell name that has been deleted Excel will return the #REF!
Similar questions