Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple conditions formula
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
Have a look at this post on mrexcel.com for a solution that avoids nesting so
many IF()'s within each other: http://www.mrexcel.com/board2/viewtopic.php?t=159646 "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 |
#4
|
|||
|
|||
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")))) |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
multiple conditions formula
Will =if(and(a10,c10,e10),a1+c1+e1,(o) it doesn't seem to work for me. Any
ideas? diferent syntax for formula? =if(a10,if(c10,if(e10,))),a1+c1+e1,(0) Iwill try this "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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple conditions formula
Change your AND formula into an OR formula.
=IF(OR(A60,D60,F60),9.75,("")) "Curt" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula with multiple IF'S | Excel Discussion (Misc queries) | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) |