ref in excel indicates that the cell reference is invalid. The solution is: first open the Excel file and select the cell; then enter the source data table; and finally modify the source data table.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, DELL G3 computer.
#REF appears in Excel because the cell reference is invalid.
Solution
Display #REF in the cell as shown.
Select the cell and you can see the source data in other tables.
Enter the source data table and you can see that there are errors in the source data table.
Modify the source data table.
Return to the page and the formula will return to normal.
[Recommended learning:Excel tutorial]
The above is the detailed content of What does ref mean in excel. For more information, please follow other related articles on the PHP Chinese website!