hide errors
 

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.

hide errors
 

How about this:

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

Copy the formula down as needed.

HTH,
Elkar


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

hide errors
 

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.
Elkar wrote:
How about this:

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

Copy the formula down as needed.

HTH,
Elkar


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

hide errors
 

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.

hide errors
 

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.

hide errors
 

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.


"michaelberrier" wrote:

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.