Okay, so I need what I believe will be an IF function. It's for grade results.
The formula is based on the results of B7.
If B7 is greater than 90, then B8="A". But, here's the part I can't figure out. If B7=80 thru 89, then B8="B", and so on for the other grades.
Or maybe I need to achieve this a different way altogether? I'm open to suggestions.
MacBook Pro (Retina, 13-inch,Early 2015), macOS Sierra (10.12.3)
One way, which assumes you don't have too many different letter grades to keep track of, is to use a "nested if" formula:
=IF(B7≥90,"A",IF(B7≥80,"B",IF(B7≥70,"C",IF(B7≥60,"D","F"))))
I recommend having a look at the 'Grade Book' template at File > New in your menu. It has a more sophisticated scheme that accounts for A+, A- etc., using VLOOKUP to look up the letter grade in another table. To see how it does this, click cell H4 and look at the formula there.
SG
Oh goodness. You've helped me see what I was doing wrong. My issue was I wasn't using the proper symbol. I was trying to work with a simple 'greater than' scenario. Thank you so much!
Numbers - IF function, using a range of numbers
