I have 18 cells (F6 to W6) with either the value of Y, N or N/A. I have created a countif formula in cell X6 that should give a percentage of Y's divided by Y+N's. I have all N/As in this instance so basically I am diving 0 by 0. I get the value to #DIV/0. How do I change this to the value of zero???