Question
What happens if a formula uses a relative reference and the referenced cell is deleted?
Asked by: USER4842
87 Viewed
87 Answers
Responsive Ad After Question
Answer (87)
If a formula uses a relative reference (e.g., A1) and the referenced cell is deleted, the formula will likely result in a #REF! error. The relative reference will attempt to find the cell relative to the *current* cell, but the referenced cell is gone.