hide errors

C

Confused

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.
 
E

Elkar

How about this:

=IF(ISERROR(AVERAGE(C8:AV8)),"",AVERAGE(C8:AV8))

Copy the formula down as needed.

HTH,
Elkar
 
M

michaelberrier

You could try conditional formatting to turn the font white when an
error is present. First, select all the cells you want to apply this
to, then Format-->Conditional formatting Select "Formula Is" from drop
down box then put this in the box "=ISERROR(A1)" Change A1 to whatever
the first cell in the colunm is. Then, click Format and, on the Font
tab under Color, select white. Then, when you have a Div/0 error, it
will be the same color as your cell an thus invisible.

Hope that does it for you.
 
C

Confused

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.
 
M

michaelberrier

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

Confused

There actually isn't an error in this case just a number value that needs to
be used as a product of the average to the given number 1 for the weight of
the grade.
 
Top