Simon,
Either test for the 0 value first [=IF(Whatever=0,,,,,]
or test the result for the error [=IF(ISERROR(Whatever),,,,

NickHK

"Simon Lloyd"
wrote in message
...

Hi,

Can anyone tell me how to cure the div/o fault on my spread sheet when
no value is found......just to tidy things up?

Thanks,

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=396012