#DIV0/! issues

  • Thread starter Thread starter Brento
  • Start date Start date
B

Brento

Hello,

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

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

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


any help would be great as I have tried to figure this out for mysel
for hours?
thanks
Bren
 
Brento said:
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.
Click to expand...

=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
 
Back
Top