Confused,
I think the Conditional thing would fix that problem too since it
doesn't reside in the cell.

Confused wrote:
Thanks for the assistance that worked !!!!!

Now I totally forget how I can hide a value until it is being used.

eg. once the numbers are averaged I have a weighted numebered applied 1 and
that number now shows up without error. I need that hidden as well as the
other 2 that I am using.


"Confused" wrote:

I am working on creating a grade book for my school and the problem that I am
having is when I get across to the end of a column where I have this command
average(c8:av8) when I have no numerical entries I get a #DIV/0! error. After
reading through many different forums on hiding such numerous errors I still
can't figure out how to hide more than one at a time without them reappearing
once the first error has changed.