space left for future entry = #DIV/0!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

clooney - 23 May 2006 17:56 GMT

I'm making a sheet to calculate my grades, but since its the beginning
of the semmester, the spaces aren't filled in yet. How do i ignore a
cells until they have a value?

Signature

clooney

Reply to this Message

Ardus Petus - 23 May 2006 18:07 GMT

=IF(ISERROR(<your stuff>,"",<your stuff>))

HTH
--
AP

"clooney" <clooney.289sa5_1148403671.6072@excelforum-nospam.com> a écrit
dans le message de news:
clooney.289sa5_1148403671.6072@excelforum-nospam.com...

> I'm making a sheet to calculate my grades, but since its the beginning
> of the semmester, the spaces aren't filled in yet. How do i ignore a
> cells until they have a value?

Reply to this Message

CLR - 23 May 2006 19:57 GMT

Specifically, it depends on the formula......
instead of
=AVERAGE(A1:A10)
you could use
=SUM(A1:A10)/COUNT(A1:A10)

Vaya con Dios,
Chuck, CABGx3

> I'm making a sheet to calculate my grades, but since its the beginning
> of the semmester, the spaces aren't filled in yet. How do i ignore a
> cells until they have a value?

Reply to this Message

clooney - 24 May 2006 14:46 GMT

I tried the count function, but doesnt that just count the number of
cells that have entries rather than an actual sum..?

email me if you want and Ill send you the file so you can take a look
yourself.

thanks.
clooney@stlcop.edu

Signature

clooney

Reply to this Message