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