Question: Here is a worksheet. B. Final exam score: 50 Grade: C You enter a final exam score in cell B1. The score is a
Here is a worksheet. B. Final exam score: 50 Grade: C You enter a final exam score in cell B1. The score is a number from 0 to 100. Based on the score, you assign a grade of A, B, C, Dor Frepresenting different ranges of the final exam score. If you can only use the IF cell formula function to do that, what is the minimum number of IF functions that you need to use? For example, if there are two grade letters, A and B, that you need to display, you will need only one IF function to display one of the two grades, i.e.: =IF( Condition "A", "8") You need to write the answer clearly in the box below. Activate Go to Settin
Step by Step Solution
3.43 Rating (166 Votes )
There are 3 Steps involved in it
To determine the minimum number of IF functions needed we have to consider that we hav... View full answer
Get step-by-step solutions from verified subject matter experts
