View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sirjbean@gmail.com is offline
external usenet poster
 
Posts: 2
Default Getting rid of #DIV/0!

This is the formula I'm using =sum(E12*100)/F12. If E12 is left
blank with no entry I get #DIV/0!. How can I get rid of that result
without having to put a zero in E12?