https://ccn-wiki.caset.buffalo.edu/index.php?action=history&feed=atom&title=Excel_FormulasExcel Formulas - Revision history2026-04-09T05:38:37ZRevision history for this page on the wikiMediaWiki 1.39.3https://ccn-wiki.caset.buffalo.edu/index.php?title=Excel_Formulas&diff=1393&oldid=prevChris: /* Letter Grade Conversion */2017-12-21T17:33:25Z<p><span dir="auto"><span class="autocomment">Letter Grade Conversion</span></span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:33, 21 December 2017</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Letter Grade Conversion==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Letter Grade Conversion==</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immediate right (column AA):</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Here is a formula for converting a percentage to a letter grade <ins style="font-weight: bold; text-decoration: none;">using the score breakdown at UWO</ins>. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immediate right (column AA):</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> =IF(Z2>=90,"A",IF(Z2>=85,"A-",IF(Z2>=80,"B+",IF(Z2>=75,"B",IF(Z2>=70,"B-",IF(Z2>=65,"C+",IF(Z2>=60,"C",IF(Z2>=55,"C-",IF(Z2>=50,"D","F")))))))))</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> =IF(Z2>=90,"A",IF(Z2>=85,"A-",IF(Z2>=80,"B+",IF(Z2>=75,"B",IF(Z2>=70,"B-",IF(Z2>=65,"C+",IF(Z2>=60,"C",IF(Z2>=55,"C-",IF(Z2>=50,"D","F")))))))))</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Here's how the percentages convert to letter grades using the typical UB thresholds</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> =IF(Z2>=94,"A",IF(Z2>=90,"A-",IF(Z2>=87,"B+",IF(Z2>=83,"B",IF(Z2>=80,"B-",IF(Z2>=77,"C+",IF(Z2>=73,"C",IF(Z2>=70,"C-",IF(Z2>=65,"D+",IF(Z2>=60,"D","F"))))))))))</ins></div></td></tr>
</table>Chrishttps://ccn-wiki.caset.buffalo.edu/index.php?title=Excel_Formulas&diff=984&oldid=prevChris at 02:27, 1 June 20172017-06-01T02:27:29Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:27, 31 May 2017</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">==Letter Grade Conversion==</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immediate right (column AA):</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immediate right (column AA):</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> =IF(Z2>=90,"A",IF(Z2>=85,"A-",IF(Z2>=80,"B+",IF(Z2>=75,"B",IF(Z2>=70,"B-",IF(Z2>=65,"C+",IF(Z2>=60,"C",IF(Z2>=55,"C-",IF(Z2>=50,"D","F")))))))))</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> =IF(Z2>=90,"A",IF(Z2>=85,"A-",IF(Z2>=80,"B+",IF(Z2>=75,"B",IF(Z2>=70,"B-",IF(Z2>=65,"C+",IF(Z2>=60,"C",IF(Z2>=55,"C-",IF(Z2>=50,"D","F")))))))))</div></td></tr>
</table>Chrishttps://ccn-wiki.caset.buffalo.edu/index.php?title=Excel_Formulas&diff=982&oldid=prevChris: Chris moved page Excel Forumulas to Excel Formulas: Typo2017-06-01T02:26:56Z<p>Chris moved page <a href="/index.php/Excel_Forumulas" class="mw-redirect" title="Excel Forumulas">Excel Forumulas</a> to <a href="/index.php/Excel_Formulas" title="Excel Formulas">Excel Formulas</a>: Typo</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:26, 31 May 2017</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>Chrishttps://ccn-wiki.caset.buffalo.edu/index.php?title=Excel_Formulas&diff=980&oldid=prev38.95.246.48: Created page with "Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immed..."2017-05-24T18:35:03Z<p>Created page with "Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immed..."</p>
<p><b>New page</b></p><div>Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immediate right (column AA):<br />
=IF(Z2>=90,"A",IF(Z2>=85,"A-",IF(Z2>=80,"B+",IF(Z2>=75,"B",IF(Z2>=70,"B-",IF(Z2>=65,"C+",IF(Z2>=60,"C",IF(Z2>=55,"C-",IF(Z2>=50,"D","F")))))))))</div>38.95.246.48