Want #DIV/0 cell blank

Microsoft Microsoft excel 2000
April 23, 2010 at 04:09:02
Specs: Windows 2000
I'm developing a form to get GPA's for a 2 year private school's classes. If a person has not taken a quarter it is blank. If you have 4 cells (classes)A1:A4 and use averaga to get your answer (GPA) but they haven't taken that quarter therefore no values. What is the formula if I don't want to show the #DIV/0 but a blank cell.

PS I have tried ISERROR but to no avail.

Thanks Fr Guido

See More: Want #DIV/0 cell blank

Report •

April 23, 2010 at 07:09:46
Wrong forum.

Report •
Related Solutions

Ask Question