mmoran wrote:
I am a teacher and am working on excel for my grades. I am tyring to write a
formula that has an output of a letter grade. For example =if(AND (AQ3<100,
AQ390), "A" but then I want the condition of =if (AND(AQ3<89, AQ380),
"B" and so on.
How do I write this formula?
Megan
This is how I do it for my gradebook, just change the numbers and cell
references:
=IF(E4=0.91,"A",IF(E4=0.81,"B",
IF(E4=0.71,"C",IF(E4=0.61,"D","F"))))
|