Use iserror eg

=if(iserror(a1/b1),"",a1/b1)

Regards
Rowan

"Simon Lloyd" wrote:


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