multiple conditions formula

=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

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,
> 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


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"))))

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,
> 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

=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

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,
> 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

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,
> 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


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"))))

=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

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,
> 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

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,
> 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


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"))))

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,
> 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

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,
> 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


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"))))

=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

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,
> 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


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"))))

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

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,
> 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

=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

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,
> 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


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"))))

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(a6>0,d6>0,f6>0),9.75,("")) missing something in formula??

"Tom Ogilvy" wrote:

> =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
>
>
>

Will =if(and(a1>0,c1>0,e1>0),a1+c1+e1,(o) it doesn't seem to work for me. Any
ideas? diferent syntax for formula?
=if(a1>0,if(c1>0,if(e1>0,))),a1+c1+e1,(0) Iwill try this

"Tom Ogilvy" wrote:

> =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
>
>
>