A column in an Excel worksheet named Letter Grade contains the formula

=If(score<80,"B",if(score<70,"c",if(score<60,"d",if(score<50,"f","A")))),

and the question is what is a grade of 45, the answer should be F but why is the correct answer B?

By: hamed