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