I had this spreadsheet set up with just straight yes or no or na answers, and it worked fine, but then they filled out the sheet with y or n and some did yes or no and of course the formulas didn't work correctly. Is there a way for this formula to find the correct percentage possible if they do one way or the other or both ways?
Bookmarks