Your mixing code with worksheet functions. It is hard to tell what your
want to do.

if a worksheet function

=if(iserror(something),0,something)

--
Regards,
Tom Ogilvy

"scapen" wrote in message
...

Well, my questions is why am I still receiving the div/o error? It's
not apparent to me, if you know of a good place to go for examples that
would be great. I've been battling over this for a while.

thanks - any input/advice is appreciated.


--
scapen
------------------------------------------------------------------------
scapen's Profile:
http://www.excelforum.com/member.php...o&userid=15156
View this thread: http://www.excelforum.com/showthread...hreadid=267893