Thread: [Solved] How to prevent #DIV/0!
View Single Post
 
Old 05-28-2016, 06:41 PM
jparnold jparnold is offline Windows XP Office 2010 32bit
Advanced Beginner
  
Join Date: Jan 2012
Location: Blue Mountains, NSW, Australia
Posts: 41
jparnold is on a distinguished road
Default How to prevent #DIV/0!
I am wondering how to insert a formula into a cell which will display a blank result when the values in the cells being accessed are blank.

For example I have formula of =F4/C4*100 which displays #DIV/0! when (cells) F4 and or C4 are blank.

Thanks
Reply With Quote