# Program that outputs letter grade based on percentage?

조회 수: 1 (최근 30일)
Anne Nguyen 2019년 10월 27일
답변: Walter Roberson 2019년 10월 27일
How do I create a script that has a program that takes in a student's score from an Excel Spreadsheet (in percent, i.e. 88%), and translate's (output) it to a letter grade? For example, if a student scores 90% on a test, then that is considered a A- since an A- is 90%-93%, and if a student scores 80%, then that is considered a B- since a B- is 77%-80%. In addition, the percentage at the boundary of each grade is assigned a high grade; for example, if a student’s grade percentage is 90%, the student receives ‘A-’, not ‘B+’ (A- is 90%-93% while B- is 87%-90%). The percent the student scored will be read from an Excel Spreadsheet (I don't know if that'll make a difference in the building of the code). Any help would be appreciated, thank you!

댓글을 달려면 로그인하십시오.

### 채택된 답변

Walter Roberson 2019년 10월 27일
if this_score >= 90 & this_score <= 93
elseif this_score >= 77 & this_score <= 80
else
end

댓글을 달려면 로그인하십시오.

### 카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by