multiple conditions formula
this is close to my problem. Trying to check any of three cells for entry or
value to allow a entry into another. Example
If(and(a60,d60,f60),9.75,("")) missing something in formula??
"Tom Ogilvy" wrote:
=if(Q390,"A",if(Q3=80,"B",if(Q3=70,"C",if(Q3=6 0,"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" wrote in message
...
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
|