View Single Post
  #2   Report Post  
Kevin@Radstock Kevin@Radstock is offline
Member
 
Posts: 93
Default

Hi Excel Dumbo

Use IF & ISERROR to trap errors.

Kevin


Quote:
Originally Posted by Excel Dumbo View Post
Hi ,

Please refer the file stored in the link below and advise the mistake i have made in the formula. I am getting a #DIV error. I would like it to appear as blank. I had trouble attaching this file to this website, hence stored on to a link.

http://speedy.sh/kB4ZD/To-remove-DIV.xls

Thanks