{"id":6396,"date":"2021-11-19T05:29:39","date_gmt":"2021-11-19T05:29:39","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=6396"},"modified":"2021-11-19T05:30:31","modified_gmt":"2021-11-19T05:30:31","slug":"excel-formula-to-calculate-passing-grade","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-formula-to-calculate-passing-grade\/18279.html","title":{"rendered":"Excel Formula To Calculate Passing Grade"},"content":{"rendered":"<p>I am trying to put together a formula that will calculate the total points required to meet the minimum passing score and have a \u201cPoints Needed to Graduate\u201d reflected based on gradebook entries to date.<\/p>\n<p>POSSIBLE 100 POINTS<\/p>\n<p>MINIMUM 80 POINTS TO PASS BASED ON ANY COMBINATION OF THE FOLLOWING:<\/p>\n<p>30 POINTS MAX POSSIBLE FROM PARTICIPATION (CELL L7)<\/p>\n<p>70 POINTS MAX POSSIBLE FROM TWO EXAMS: 35 POINTS MAX TUE EXAM (CELL N7) AND 35 POINTS MAX THU EXAM (CELL O7)<\/p>\n<p>&#8220;POINTS NEEDED TO GRADUATE&#8221; IS CELL R7.<\/p>\n<p>I currently have the formula \u201c=80-(L7+N7+O7)\u201d in CELL R7 that appears to do the trick; however, if the student scores more than the minimum score of 80 (e.g., 100), the formula returns \u201c-20.\u201d I would like the formula to return \u201c0\u201d or a \u201c-\u201c for any negative score, i.e., when the score exceeds the minimum.<\/p>\n<p>Additionally, I would like CELL R7 to only calculate the \u201cPoints Needed to Graduate\u201d when CELLS L7, N7, and O7 have entries.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":7},"question-category":[53],"question_tags":[],"class_list":["post-6396","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/6396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=6396"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=6396"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=6396"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=6396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}