#Div/0 need blank cell

Microsoft Microsoft excel 2000
April 26, 2010 at 13:29:05
Specs: Windows 2000
I'm developing a form (template) to calculate GPA's for a 2 year private school's classes. If a person has not taken a quarter it needs to be blank but have the formula avergea in the cell for when they do rec grades. Using avergea returns a #DIV/0 value in the cell if no classes have been taken that quarter. How can I return a blank cell instead of #DIV?0?? I have tried ISERROR but to no avail.

Thanks Fr Guido

See More: #Div/0 need blank cell

Report •

April 26, 2010 at 15:54:31
re: I have tried ISERROR but to no avail

Did you try it like this?


Report •

April 27, 2010 at 06:30:24
Thank You -- It works -- PB

Report •

Related Solutions

Ask Question