How to correct a #DIV/0 error? - TechRepublic
Question
August 27, 2011 at 06:25 PM
wattle11c

How to correct a #DIV/0 error?

by wattle11c . Updated 14 years, 10 months ago

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 discussion is locked

All Comments