How to correct a #DIV/0 error?

By Wattle11c ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums