Posted by Jimmy on December 01, 2000 12:46 PM
I am using this formula
Which works fine, but my question is how can I prevent a user from inputting more than 1 "x" in the cell. If they input 2 "x's" it mess up the total count and then a average formula based on the countif formula. Is thier some way to change this formula to pop up a message box to tell them to input only one "x" or someway to format the cell to prevent more than one "x" being put in.