When a formula contains an invalid cell or range reference, the #REF! error is displayed. #REF! in Excel is short for reference, and you’ll usually see it pop up when cells that were referenced in formulas are deleted. They can be a nuisance, but they’re usually pretty simple to find and fix. Here’s how to…
The post What’s #REF in Excel and How to Fix It appeared first on Excel University.
from Blog - Excel University https://ift.tt/vdQFXoL
0 Comments