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