#DIV0/! issues

Hello,

I am having problems with div0's in my formulars.

Firstly I need to write the formular that says average a row of data and exclude div0s.

Secondly on a simple formular such as sum(a2/a1) with out data added in cells a1 and a2 will result in a div/0 and i need it to result in a blank cell and not zero.


any help would be great as I have tried to figure this out for myself for hours?
thanks
Brent

"Brento" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I am having problems with div0's in my formulars.
>
> Firstly I need to write the formular that says average a row of data
> and exclude div0s.

=IF(COUNT(2:2)=0,"",AVERAGE(2:2))

> Secondly on a simple formular such as sum(a2/a1) with out data added in
> cells a1 and a2 will result in a div/0 and i need it to result in a
> blank cell and not zero.

=IF(A1=0,"",A2/A1)

As far as I can see the function works correct.

Values in A1 to A7:
1

3
5

6
7
=average(A:A) gives 4.4 which seems correctly.

For the second problem if you want results only for numeric data in A1
and B1 use this

=IF(AND(ISNUMBER(A1),ISNUMBER(B1)),B1/A1,"")

Hans