#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
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=507504

#DIV0/! issues
 

"Brento" wrote in
message ...

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)

#DIV0/! issues
 

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