=if(Q3>90,"A",if(Q3>=80,"B",if(Q3>=70,"C",if(Q3>=60,"D","F"))))
Anything greater than 90 is filtered out by the first condition, so it
doesn't need to be considered in subsequent conditions.
--
Regards,
Tom Ogilvy
"mmoran" <[email protected]> wrote in message
news:[email protected]...
> 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,
> AQ3>90), "A" but then I want the condition of =if (AND(AQ3<89, AQ3>80),
> "B" and so on.
>
> How do I write this formula?
>
> Megan
Bookmarks