I am trying to figure our how to get the cell to return either a "0" or a blank look when there are no values using the formula in place. This is only happening when I am dividing to cells values to get a new value in that cell. When there is nothing being divided it shows #DIV/0! ....thus I would like to see something other than this while it hasn't been used. can you please help!!!