Excel Assignment I need the VLookup function to place in M5 cell to calculate le
ID: 3902474 • Letter: E
Question
Excel Assignment
I need the VLookup function to place in M5 cell to calculate letter grade
Professor Streterstein Course Final Grade Pass/Fail 99 ? ? 66 ? 98 ? ? 44 ? CONNER ? ? Student name Acosta, Angelica Alnusf, Ali AISabt, Sadon A KHA Anderson, Chester Ballantine, David Behbehani, Mohammad Beier, Susanna Blackett, Christopher Cabander, Frida Cooper, Alexander Corson, Bailey Cunningham, Brett Elenbaas, Andrew Friend, Jason Grzanowski, Michael Harkavy, Alexander Hartman, Brian High, Alexander Holobinko, Brittney Kuo, Cheng-Jung Markham, Julie Martinez, Javier McCauslin, Megan Miller, Sara O'Donnell, Devon Olwig, Thomas Parra, Matthew ? Exam 1 Exam 2 Quizz 1 Quiz 2 Quiz 3 Project 1 Project 2 Project 3 Project 4 Total Points Earned 100 77 50 48 38.5 96 37.345 97 66.22 610.065 96 78 48 37.5 39 75 37.83 93.12 67.08 571.53 75 37.5 43.5 49.5 87 48.015 72.75 85.14 597.405 43.5 48 49 96 47.53 | 84.39 84.28 637.7 48 22.5 46 45 44.62 93.12 79.12 566.36 93 22.5 39 46.5 78 45.105 43.65 79.98 492.735 3.88 75.66 6.88 3 14.42 49 1.94 64.02 3.44 321.4 49 38.5 40.255 95.06 71.38 593.695 38.5 41.225 74.69 73.1 564.015 44 23 35.89 85.36 63.64 496.89 34.92 44.62 61.92 435.46 49.5 35.89 75.66 63.64 551.69 38 37.5 76 36.375 96.03 64.5 571.905 39 44.5 43.165 73.72 76.54 557.925 56 37.83 75.66 67.08 498.57 28 21.5 32.5 31.525 54.32 55.9 387.745 21.5 49.5 36.86 41.71 65.36 470.93 49.5 43.5 87 42.195 96.03 74.82 622.545 43.5 33.5 49 47.53 84.39 84 28 33.5 44.5 32 89 31.04 64.99 55.04 481.07 44.5 50 26.5 100 25.705 86.33 45.58 520.615 | 50 33.5 100 32.495 97 57.62 587.615 50 50 44.5 100 43.165 76.54 650.205 50 27 28 54 27.16 97 48.16 487.32 32.5 21.5 65 20.855 52.38 36.98 353.215 33.5 | 2867 27.16 63.05 48.16 420.37 lo ? ? ? ? 99 ? ? ? ? ? ? ? ? ? 325 ?Explanation / Answer
Question)
I need the VLookup function to place in M5 cell to calculate letter grade
Answer)
=VLOOKUP(L5,$B$5:$C$12,2)
L5 is your value
$B$5:$C$12 is your lookp range
2 means the second value of your lookup range will be looked.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.