Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help making a Nested IF formula on excel to calculate these letter grades. Nested_IF_Statements - Excel Developer Help Search AutoSave Off Hy dro File

Need help making a Nested IF formula on excel to calculate these letter grades.image text in transcribed

Nested_IF_Statements - Excel Developer Help Search AutoSave Off Hy dro File Home Insert Page Layout Formulas Data Review View fx [ Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Function Used - Time Reference Trig. Functions Function Library @ ? A @ @ @ Define Name Trace Precedents Vi Show Formulas @ Calculate Now Calculate Now Calculation Use in Formula Name Manager 20 Create from Selection Defined Names Calculate Sheet a Trace Dependents Error Checking - FRemove Arrows - Evaluate Formula Formula Auditing Watch Window Options Calculation F6 - x fix O P Q R S T U 5 4. A B C D F G H I J K L M N 1 Calculate the percent score Grade each student using a nested IF statement with a 90% - A, 80% -B, 70%-C, 60% -D, and less that 60% D grading scale Letter 2 Student ID Points Grade % Grade Max points possible 1112 10201 862 77.52% 10212 1023 92.00% 10223 866 77.88% OF 6 10234 925 83.18% 0.6 D 10245 904 81.29% 0.7 C 10256 998 89.75% 0.8 B 10267 597 53.69% 0.9 A 10278 561 50.45% 10289 961 86.42% 10300 512 46.04% 10311 1003 90.20% 10322 775 69.69% 10333 1079 97.03% 10344 967 86.96% 10355 612 55.04% 10366 933 83.90% 10377 698 62.77% 10388 644 57.91% 10399 1106 99.46% 10410 548 49.28% 10421 978 87.95% 10432 924 83.09% 10443 545 49.01% 10454 764 68.71% 10465 643 57.82% 10476 930 83.63% 10487 544 48.92% 10498 712 64.03% 10509 959 86.24% 10520 552 49.64% 10531 628 56.47% 10542 691 62.14% 10553 569 51.17% 10564 797 71.67% 10575 796 71.58% 10586 804 72.30% 10597 637 57.28% 10608 1063 95.59% 10619 528 47.48% 10630 1077 96.85% 10641 744 66.91% 10652 549 49.37% Sheet1 + 44

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions