nested IF and LOOkUP

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

Leave a Reply

Your email address will not be published. Required fields are marked *