View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
VBA Noob
 
Posts: n/a
Default #name or #div/0 problem


Try somthing like this

replace cell ref as required

=IF(ISERROR(A15/B15),"",A15/B15)


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553841