Question: The formula = IF ( B 2 5 5 , Fail,IF ( B 2 7 0 , Good, IF ( B 2 8 0 ,

The formula = IF(B255,"Fail",IF(B270,"Good", IF(B280,"Very Good", IF(B290,"Excellent", "Impressive")))) is written in C2 of the worksheet below and copied down the column. What will be the result for Harrison and Claudia?
\table[[,A,B,C],[1,Name,Points,Results],[2,Nick,45,],[3,Emily,55,],[4,John,67,],[5,Mairia,58,],[6,Kate,98,],[7,Li,80,],[8,George,100,],[9,Mark,90,],[10,Harrison,85,],[11,Claudia,70,],[12,Morris,96,]]
Select one:
Excellent, Very Good
Excellent, Good
Good, Good
Excellent, Impressive
Impressive, Good
The formula = IF ( B 2 < 5 5 , "Fail",IF ( B 2 <

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!