Question Locked
How to correct a #DIV/0 error?
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have read numerous posts and watched a thousand videos on how to correct a DIV/0 error but can't seem to get mine to do the same. I am averaging cells C4 to F4. And as the cells are blank I want the averaging cell (G4) to also remain blank until data is entered (as it is the cell that has the #DIV/0 error). Is that possible?