Numbers 1.2 - Determine Letter Grade using IF Function

In this activity we needed to use a nested IF statement to have Excel take a numerical grade and convert it into a letter grade (A-F).  Getting the formula working was a bit tricky.  I don't remember working with IF functions before so the first few times I tried, I wasn't able to get the correct outcome.  All those open and close parenthesis were tricky!

For some reason the Excel help feature was not working on my laptop.  I'm wondering if it didn't get loaded with the software for some reason.  When searching 'If Function' I was getting no items in the help contents at all.  So, I was relieved that Dr. Pierce offered this link on the assignment sheet to look at the formula.  From the example I was able to set up the IF statement and got it working.

Must be a difficult class.  No one got an 'A' for the semester.

My Grade spreadsheet can be found on Google Docs.

NETS:
3d:  As a teacher, using Excel as a grade book makes use of current digital tools to analyze and evaluate students' learning.