Question: The formula , Fail,IF ( B 2 7 0 , - Good, IF ( B 2 8 0 , Very Good, IF ( B 2

The formula
, "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 Nick and Li?
\table[[4,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,]]
The formula , "Fail",IF ( B 2 < 7 0 , - "Good",

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!