Hello Everyone,
At work I'm trying to create an evaluation form that has three options: Pass, Fail, and N/A as responses to questions. The responses are tied in to points, for example: Pass 2, Fail 0, and N/A (blank). The goal is to have the N/A option not count against the points if it is selected, so that way the Pass/Fail questions would have more weight on the score. It used to be a Pass/Fail system, and I tied it in to points in another column and it worked out. How can I create a formula to include the N/A option not counting against the points? I have attached what I have so far. Thank you for your time. Sincerely, Anthony
Bookmarks